From: Warren Young
Date: October 27 2005 5:58am
Subject: Re: Retrieving 300K+ records
List-Archive: http://lists.mysql.com/plusplus/5061
Message-Id: <43606C6A.3090104@etr-usa.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Alex Vishnev wrote:
> 
> it is still not the same as with using flat file (2-3sec). 

Of course it's slower.  Nothing is faster than a flat file.  You've 
added the overhead of a separate process (mysqld) plus the IPC necessary 
for the it to talk to your process, plus any conversions and such going 
on within libmysqlclient.

You must be moving from flat files to a real database to get some 
benefit.  You sound surprised that those benefits have a cost.