> >> I have a table with 5,000,000 records that takes about 1 second > >> to show the results. > > > > All rows? > > No. The queries return an average of 30 rows. > > I just wanted to say that the problem isn´t the table size, but the > query X indexes used.
Right :-) I just wanted to say that it's a weird statement that "results" are always shown in about 1 second. This depends on your queries as well :-) With regards, Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL Server Upscene Productions http://www.upscene.com Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
