Posted by Stefan Rybacki on 09/27/05 00:32

Bob Bedford wrote:
>> 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).

Ok whatever the reason was, hopefully you won't get such a behaviour again.

Good luck.

Stefan

>
> Cheers.
>
> bob
>

[Back to original message]