What table type is this? If it's MyISAM select count(*) should be instantaneous. If it's InnoDb and you've got a large dataset (say 1 million+) then select count(*) will be slow b/c it doesn't store the # of records in the table, thus it has to count records. MyISAM does store the count so it will be much faster.
>>> Becoming Digital <[EMAIL PROTECTED]> 06/13/03 01:49PM >>> MySQL should have no problems running on your system, and if it runs better on another box, that would indicate a configuration problem or background processes clogging up the works. If you post your my.cnf file, someone here might be able to rule out the former. Edward Dudlik Becoming Digital www.becomingdigital.com ----- Original Message ----- From: "blackrat" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, 13 June, 2003 13:37 Subject: Machine requirements 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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
