[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