On the linux box it's 2.8 secs with only one index (on clicks) and no fk's. W/O, it's 1.8 secs. Both were done after 'vacuum analyze' and 'reindex table stats'.
John
Stephan Szabo <sszabo@megazone23.bigpanda.com> wrote:
On Tue, 4 Feb 2003, John Smith wrote:
> That works - updates on foo take about 1.4 seconds. I dropped all the
> indexes and fk's on stats and updates there take about 2.8 seconds.
> These are on the cygwin machine.
The 2.8 seconds is on stats after dropping the fks and indexes? But
it didn't help on the linux box?
Have you done a vacuum/reindex recently?
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable.
Sign up now