[Wikitech-l] Using MySQL as a NoSQL

2010-12-23 Thread Nikola Smolenski
I have recently encountered this text in which the author claims very high MySQL speedups for simple queries (7.5 times faster than MySQL, twice faster than memcached) by reading the data directly from InnoDB where possible (MySQL is still used for writing and for complex queries.) Knowing

Re: [Wikitech-l] Alternative to opendir() functions?

2010-12-23 Thread Chad
On Tue, Dec 21, 2010 at 12:36 PM, Brion Vibber br...@pobox.com wrote: Tell you what -- 10 uses of opendir shouldnt take too long to replace; write the code and let's see how it actually looks. Us all sitting in the list bikeshedding won't be much use, but if it makes the code cleaner, hey win!

Re: [Wikitech-l] Alternative to opendir() functions?

2010-12-23 Thread Aryeh Gregor
On Thu, Dec 23, 2010 at 1:47 PM, Chad innocentkil...@gmail.com wrote: Well it's in trunk now[0] (plus a few followups). It's shorter, yes. Some profiling before/after would probably be good. It's shorter by only a handful of lines, at the expense of using an obscure library rather than built-in

Re: [Wikitech-l] Alternative to opendir() functions?

2010-12-23 Thread Ilmari Karonen
On 12/22/2010 12:16 AM, Platonides wrote: We are only using opendir for getting a full directory list. That's a good point. Perhaps what we need is simply a utility method to list all files in a directory. In fact, I just realized that PHP already has one. It's called scandir(). Its only

Re: [Wikitech-l] Using MySQL as a NoSQL

2010-12-23 Thread Platonides
Nikola Smolenski wrote: I have recently encountered this text in which the author claims very high MySQL speedups for simple queries (7.5 times faster than MySQL, twice faster than memcached) by reading the data directly from InnoDB where possible (MySQL is still used for writing and for

Re: [Wikitech-l] Using MySQL as a NoSQL

2010-12-23 Thread George Herbert
On Thu, Dec 23, 2010 at 5:19 PM, Platonides platoni...@gmail.com wrote: Nikola Smolenski wrote: I have recently encountered this text in which the author claims very high MySQL speedups for simple queries (7.5 times faster than MySQL, twice faster than memcached) by reading the data directly

Re: [Wikitech-l] Using MySQL as a NoSQL

2010-12-23 Thread Anthony
On Thu, Dec 23, 2010 at 9:34 AM, Nikola Smolenski smole...@eunet.rs wrote: I have recently encountered this text in which the author claims very high MySQL speedups for simple queries (7.5 times faster than MySQL, twice faster than memcached) by reading the data directly from InnoDB where