Re: Big speed problem with MySQL

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" <milesthompson@ns.sympatico.ca> a écrit dans le message de news: 5.0.2.1.0.20020215101004.017c4be8@pop1.ns.sympatico.ca... > 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 > >arthur@voip-telecom.com > > > > > > > >-- > >PHP Database Mailing List (http://www.php.net/) > >To unsubscribe, visit: http://www.php.net/unsub.php >