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 speed on great tables ? How do I
set or create them ?
Thanks for your answers ...
"Miles Thompson" <[EMAIL PROTECTED]> a écrit dans le message de
news: [EMAIL PROTECTED]
> 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 +0100, Arthur CARANTA wrote:
> >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 download a dumb file generated by random text by PHP, the transfer
> >(on my LAN) is fast 50Kb/s (for example). But if this file is generated
> >PHP from data collected in MySQL (which base is on the same PC than PHP
> >webserver) then the transfer rate is less than 3.5Kb/s!!!
> >I don't know what to do ... The consequence of that is that the PHP
> >are stopped because of script timeout.
> >Anyone has an idea to save me ?
> >[EMAIL PROTECTED]
> >PHP Database Mailing List (http://www.php.net/)
> >To unsubscribe, visit: http://www.php.net/unsub.php
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php