did you check to make sure your database is using the index fetch plan you expect?
I recall with MySQL sometimes indexes would fail but there would be no indication until I actually reviewed the fetch internals… something chuck would know off the top of his head I’m sure… On Mar 7, 2014, at 12:02 PM, Robin Smith <[email protected]> wrote: > 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/jtayler%40oeinc.com > > This email sent to [email protected]
_______________________________________________ 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]
