Hi All We have been experiencing some performace issues with our DB queries that we have narrowed down to the "limitClause" applied to sql queries. It seems that out of the box MySQL uses no indexes when supplied with a LIMIT clause.
Taking this into consideration we were wondering if anything like batch fetch iterator rely on the limit clause being applied to queries or if we could safely remove (or add switch to) this part of _MySqlPlugin. Thanks Robin -- Robin Smith Engineering Team Leader BEng (Hons) MBCS -- ------------------------------ http://www.clicktravel.com Think: Do you really need to print this email?
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
