> -----Original Message----- > From: D. Richard Hipp [mailto:[EMAIL PROTECTED] > Sent: Wednesday, January 14, 2004 10:13 AM > To: Michael Hunley; [EMAIL PROTECTED] > Subject: Re: [sqlite] Re: [inbox] Re: [sqlite] Optimizing a query > > > But it is also still really fast. Do this: Run the same query > on SQLite, PostgreSQL, MySQL, and Oracle and see which one > finishes first. I've not tried it so I don't know what will > happen. But I'm guessing SQLite will be the clear winner. > Somebody please correct me if my guess is wrong.
Yeah, I actually did perform the query in MySQL also, and MySQL *seemed* slightly faster (no actual rigorous benchmarks) but not hugely so. But this was on an older MySQL that had no transaction support, and I do need to issue this particular query in a transaction context, so that may change things. -Ken --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
