Hello, I have aproximately 1,000,000 rows and I would like to do some query. The first one is to get the number of row so I do :
mysql> SELECT COUNT(*) FROM `Log`; +----------+ | COUNT(*) | +----------+ | 969129 | +----------+ 1 row in set (0.00 sec) mysql> SELECT COUNT(*) AS `Nb` FROM `Log` WHERE `ID` = 49; +--------+ | Nb | +--------+ | 969129 | +--------+ 1 row in set (1 min 20.99 sec) But like you can see it, it take a long with the WHERE clause. I use Pentium III at 650 Mhz with 48 Mb of ram. I think that the probleme come from the computer but I'm not shure (I need more RAM ?). Thanks in advance. -- Arno -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]