I don't know what your queries look like, but faster disks is always a good start when you need to transfer lots of data.
That said, I have found that with MySQL, if I need to process lots of records, it's often quicker to do it in increments rather than in one big block. For instance, if you need to retrieve data for an entire day, it may be quicker to grab the data in one hour increments and merge the results in your front end. If you can keep MySQL from having to swap out to disk (i.e. sort, joins, etc), things move must faster I find.
Using this technique I managed to reduce a process that took about 5 hours down to about 40 minutes. The process merges about a 1 million record table with a 150 million record table (daily), filtering out duplicates within a certain range. Not something you would do on a web front end.
----- Original Message ----- From: "balaraju mandala" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com> Sent: Tuesday, June 20, 2006 8:06 AM Subject: i want to speed up data retriving at sql side
Hi All, I need some suggestions from you. I need to program a webbased tool, where i use Tomcat as Webserver Mysql as database. In database i have tables which have rows 300,000 to 500,000. I written but the pages are loading very slowly. What i can do in perspictive of database, so that data can be loaded faster. thankyou in advance. regards, Bala Raju M.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
