Hi,
I have tried:
mysql select count(*) from table_name where date='2005-11-07' and id=11;
+--+
| count(*) |
+--+
|0 |
+--+
1 row in set (46.42 sec)
As you may see, this query took more than 46 seconds and I don't know why.
I am the single person that was using
.
- Original Message -
From: Octavian Rasnita [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Monday, November 07, 2005 7:53 PM
Subject: low speed select
Hi,
I have tried:
mysql select count(*) from table_name where date='2005-11-07' and id=11;
+--+
| count
Octavian Rasnita [EMAIL PROTECTED] wrote on 11/07/2005 01:53:06 PM:
Hi,
I have tried:
mysql select count(*) from table_name where date='2005-11-07' and
id=11;
+--+
| count(*) |
+--+
|0 |
+--+
1 row in set (46.42 sec)
As you may see, this query took
At 12:53 PM 11/7/2005, you wrote:
Hi,
I have tried:
mysql select count(*) from table_name where date='2005-11-07' and id=11;
+--+
| count(*) |
+--+
|0 |
+--+
1 row in set (46.42 sec)
As you may see, this query took more than 46 seconds and I don't know why.
I