As it happens, I found this post useful tonight for an almost identical
situation.
I have a table with exactly 200,000 rows, the first column is an
autoincrement ID field. I am confident that all IDs are consecutive and
there are no holes.
When I do:
Select ID from history where id = CAST(
Hi,
with a table with 33 rows, i have the row in 0s using index on term.
mysql> select * from tx where term like 'Britney Spears' ;
+++
| id | term |
+++
| 327681 | Britney Spears |
+++
1 row in set (0.00 sec
hi,
i followed this thread and really think that this isn't a locking problem, but a
table structure problem.
if there is a column in table with a boolean flag (dealt yes/no) the queries go
just looking for rows where dealt=0 (or no).
Mathias
Selon Duncan Hill <[EMAIL PROTECTED]>:
> On Friday 1
