Clear questions and runnable code get the best and fastest answer |
|
PerlMonks |
Re: How to count rows using DBI & mysql - Performance resultsby busunsl (Vicar) |
on Jun 11, 2001 at 14:59 UTC ( [id://87444]=note: print w/replies, xml ) | Need Help?? |
Some things that might have an influence on the benchmarks, depending on the RDBMS:
If you just test for existence, you can use the exists function in a bit of sql-code:
An index on the columns in where clause might have a huge impact if you use count(*).
In Section
Meditations
|
|