• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag
 

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
MySqlPlugin
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

MySqlPlugin

  • Subject: MySqlPlugin
  • From: Robin Smith <email@hidden>
  • Date: Fri, 07 Mar 2014 17:02:21 +0000
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@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden
  • Follow-Ups:
    • Re: MySqlPlugin
      • From: Jesse Tayler <email@hidden>
  • Prev by Date: Re: My last WOWODC
  • Next by Date: Re: MySqlPlugin
  • Previous by thread: Re: WebObjects-Projects?
  • Next by thread: Re: MySqlPlugin
  • Index(es):
    • Date
    • Thread