[thelist] huge MySQL query in ASP without stored procedures
Brian Cummiskey
Brian at hondaswap.com
Mon May 8 14:29:46 CDT 2006
Canfield, Joel wrote:
> our call record db is on MySQL 4.1 so as far as I know we can't use
> stored procedures. any tips on running a 400-line query in an ASP page?
I too work with call recordings on a daily basis. While I do have some
mucked up procedures, none are that kind of a query, unless they are
case statements.
Any chance you can host a txt file of the query? Without seeing it,
it's hard to say how to optimize it.
More information about the thelist
mailing list