It's called indexing and your queries should return in under 1 sec unless you are pulling all your records and all your data. Show us your Queries and you table structure and I am sure we can help.
Roger > -----Original Message----- > From: Binay Agarwal [mailto:[EMAIL PROTECTED] > Sent: Sunday, August 10, 2003 7:08 PM > To: [EMAIL PROTECTED] > Subject: Quick ones to speed up acces! > > > Hi everybody! > > I am querying from a table containing more than 40,000 records. > Earlier when the records were 10,000 it was taking 9 sec and now > after 1 year and 40,000 records its taking 30 sec. Code is the same. > > I am pretty sure that it has something to do with database only. > No body can think of spending 30 secs for retrieving values from > tables unless it's very huge in the sense of millions of records. > > I don know whether I have to modify my database or do some sort > of restructuring or reindexing so as to make it fast enough. > > Is there some methods or optmization which can be applied to this > database which hasn't been touched since design to enhance the spped. > > If there are some quick ones but valued alottttttt please let me know. > > > Thanks in advance > > Binay > > --- > Incoming mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.507 / Virus Database: 304 - Release Date: 8/4/2003 > --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.507 / Virus Database: 304 - Release Date: 8/4/2003 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]