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 a
"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
.
- Original Message -
From: "Octavian Rasnita" <[EMAIL PROTECTED]>
To:
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-
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 t
