Slow retrieve of records

[Ray Gear]

I have rewritten a database front end in Delphi 7 using the libmysql.dll and moved the database from parodox to mySQL. It is working well except that retrieve records is very slow.

As a test I did the following:
a) In a DOS box I typed mysqld to start a server
b) typed mysql to get a client
c) typed my query "SELECT * FROM songs"
The retrievial of 4071 records took 34 seconds!

While the same sever was still running I started mysqlcc and typed the same query.
Retrieval of 4071 records took 0.21 seconds.

As a newbie to mySQL I'm stumped. Where is the problem. The same server session gives widely different results depending on where I type the query.

Any suggestions on how to speed up the retrieval of records would be greatly appreaciated.

Thanks

Ray