Richard Huxton wrote:
>Depends on usage patterns and how you build your application. There are a
>couple of oddities with workarounds: count() and max() aren't very optimised
>for example.
>
You can 'fix' the max() SNAFU with a new query of the form
"select field from tbl limit 1 order by field desc" (not precise syntax, but the idea is correct)
I call it a SNAFU since it I hate to have to change queries from something obvious to a more obscure format just to
workaround an optimizer issue.
Not sure if there is an equivalent query to make count() work faster
Charlie
--
Charles H. Woloszynski
ClearMetrix, Inc.
115 Research Drive
Bethlehem, PA 18015
tel: 610-419-2210 x400
fax: 240-371-3256
web: www.clearmetrix.com