Ok I found what was the main source of slowlyness in my application : awful
coding I made, which make several thousands of useless big queries !!! So I
am optimizing my system.
Nevertheless, I am new to DB cogin, so could you tell me more on Indexes ?
What do they do ? Do they really incease spee
How are you fetching the data?
Do you have indexes on the key fields used in queries?
Are you doing the work in SQL or sorting /rearranging a lot of arrays?
There are many possibilities for slowness, but you have to tell us what
you're doing.
Regards - Miles Thompson
At 11:53 AM 2/15/2002 +010
Hi everyone.
I have a big problem with my billing software.
I have coded it using PHP and MySQL as the database.
Everything seems ok, but when I do accesses to my DB, it is very slow !
For example, I am able to download the csv file for a specified account
(that is not the problem).
If I downl
