From: Martijn Tonies
Date: November 22 2005 1:34pm
Subject: Re: Tips for better performance
List-Archive: http://lists.mysql.com/mysql/192003
Message-Id: <028301c5ef69$736ee860$c802a8c0@martijnws>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 8bit


>
> I have a table with 5,000,000 records that takes about 1 second
> to show the results.

All rows?

> Perhaps your queries arenīt optimized properly.

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