Locally just now, 10000ms. for a single date param. But it actually executes twice. The first time the select clause it a bit different (just counts of a few fields) , cause the user wants the page to go different locations depending on the number of invoice type / invoices / patients returned.
This specific query executes when the number of invoices > 1 and number of patients > 1 It doesn't help that the specification of an invoices requires so many left outer joins....... or that the number of potential paramters totals 50 or so. >>> [EMAIL PROTECTED] 07/18/05 10:29 am >>> man thats some query! whats the execution time on something like that? --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
