hmmm… I’m thinking that’s the trouble I’m referring to.
Do you know how to view your query plan in mysql? often these query plans check the index, decide it’s faulty and then fallback to scan the whole table. of course, no idea what you’re working on, but I know I’ve run into that before and it was a drag until I noticed the plan was not getting used at all! ack! On Mar 7, 2014, at 1:20 PM, Robin Smith <[email protected]> wrote: > I'm not sure about fetch plans, all i know at the moment is if i remove the > LIMIT query i get millisecond performance on my query but if i include a > LIMIT clause i get a full table scan. > > > On 7 March 2014 17:15, Jesse Tayler <[email protected]> wrote: > 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] > > > > > -- > 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]
