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 rate >(on my LAN) is fast 50Kb/s (for example). But if this file is generated by >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 programs >are stopped because of script timeout. > >Anyone has an idea to save me ? > >Arthur >[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
