select count(*) from tablename
Any other query that you filter on should have a index on the search field. At 3 million rows, nothing is going to be fast without creating indexes. Try to doing an explain before your query to see what MySQL is doing.
I develop on a 300Mhz G3 Mac Portable width 384MB RAM, and while slow, nothing as slow as what you are seeing on a far faster system.
On Friday, June 13, 2003, at 01:37 PM, blackrat wrote:
I've just started using mySql. I'm an experience programmer with SQL based database, but know nothing about mySql. I'm setting up a single user database to be accessed with some Perl programs, with one main table, which will contain about 3 million lines. I'm running on an Athlon 1250 with 384meg ram, and finding the response time too slow.
Just getting a count of the number of records by typing in an SQL query [not using Perl] takes over a minute, also when access is going on, I can't do anything else on them machine like access the web, it becomes too slow to be usable.
Am I better setting up the database on another computer and accessing it through TCP/IP. I have available a spare machine which is a Celeron 450.
-- Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
