Posted by Bob Bedford on 09/26/05 23:49

> Not sure about that. What kind of index was it? Are makecode and and
> modcode primary keys?
I've several fields for linked tables. I've created indexes for such fields
to accelerate results.
Modcode is an index. not makecode.

> If yes you don't need indices on them. But consider mysql can only use one
> index per table, so if you're often seraching or connecting by a non
> primary key attribute a combined index makes sense.
I've 50 tables with about 10 connected tables at every query. This is the
only one that fails. Other query are bigger and more time consuming and they
don't fail.

> But your problem is really odd and shouldn't appear. What are you specs
> (cpu, ram, mysql version, os, hdd, configuration)?
Don't know the web server, but they are quite good on hosting, they are
recommended for bigger sites than our.

> It seems there is something wrong with your configuration since you told
> me its working fine under winxp (same specs besides linux?).
My XP takes more time to execute queries than on the server. So the problem
seems not the machine.

Regars Stefan and thanks for your help.
I finally fixed it, probably database structure (I'm not a professional
database guy, I'm a php programmer).

Cheers.

bob

[Back to original message]