Kevin Cully wrote: > In fact, after a quick test with a query that was not optimized on an > index, the LIMIT time took longer. > > SELECT ordPK, ordFinalDisposition FROM tblOrders WHERE > ordFinalDisposition='In Process' ORDER BY ordPK > > The above select took 0.29 seconds. The EXPLAIN indicated that it was > using the WHERE, and FILESORT > > SELECT ordPK, ordFinalDisposition FROM tblOrders WHERE > ordFinalDisposition='In Process' ORDER BY ordPK LIMIT 1 > > The above select took 0.77 seconds. The EXPLAIN indicated that it was > using the WHERE but not the file sort. The LIMIT may have actually hurt > in this instance. I'm not a MySQL performance expert though. Interesting. > Yes, interesting! Thanks for running that test!
> > Nope, I didn't mean MS SQL Server. I meant any SQL Server as compared > to VFP tables. MySQL, PostgreSQL, Oracle, etc. I like the backup > features such as that the SQL Server can back itself up at scheduled > dates and times. I like that the tables can physically reorder > themselves. I like that I can modify the structures without kicking > every single user off the system because there's always someone that > hasn't shut down when told to do so. > I agree 100%. Was liking that myself just yesterday when I had a bulk insert process running and I wanted to remove some indexes so as to expedite the import! > I figure for my sessions at FoxForward, that I'll develop my example > applications using PostgreSQL because I've heard such great things about > it and no one else is presenting on PostgreSQL, so I thought I'd slip it in. > That'd be GREAT, as I'd love to see something on PostgreSQL! -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com "Work smarter, not harder, with MBSS custom software solutions!" _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/%(messageid)s ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
