Other option may be to still use the same database engine but have a transparent caching layer in between. I really wanted to get people to step back away from the problem with a solution and back to the problem itself.
On 23/03/2010, at 10:48 AM, Simon Russell wrote: > Hi there, my first post. > > The Mysql in-memory database is pretty basic; sort of like MyISAM, but > with even fewer features. To me it sort of defeats most of the > purposes of testing to test against a completely different database > engine (that doesn't even try to support the same features). I think > some time ago (somewhere else) there was mention of another database > engine that could do in-memory stuff, I can't remember what it is. > > On Tue, Mar 23, 2010 at 10:44, David Lee <deathtoallfanat...@gmail.com> wrote: >> Last time i benchmarked it vs postgresql tuned for testing (no fsync, etc) >> PG came out on top on the suite i was running by a reasonable margin. If >> memory serves ... i think it was partly because sqlite is so crippled (no >> subselects, etc) it had to run (sometimes vastly) more queries to do the >> equivalent work. >> That was a couple years ago - if anyone has better datapoints throw them in >> ... >> Interesting to know mysql has the same feature, as it's less handicapped >> than sqlite. Maybe I'll try it out - I'm certain few of my current projects >> would work w/ sqlite, but should on mysql. >> >> On Tue, Mar 23, 2010 at 10:10 AM, Ben Schwarz <ben.schw...@gmail.com> wrote: >>> >>> Has anyone in this thread tried using an in-memory database rather than >>> looking at using SSD or re-inventing machinist? >>> Both sqlite and mysql have in-memory databases or tables. I'm sure that >>> other rdbms implementations would also. >>> >>> I've used sqlite :memory: in the past when using datamapper and found it >>> to greatly increase the runtime speed for the testing environment. >>> Surely this would prove greater gains than re-thinking machinst? >>> >>> Of course, I don't want to get in the way of your hacking project. >>> >>> On 23/03/2010, at 10:06 AM, Pete Yandell wrote: >>> >>>> I like having an empty database for each test too, but I'd be more >>>> than willing to trade that for faster tests. >>>> >>>> If it's not solved before then, anyone fancy spending some time at >>>> Railscamp working on making this happen? >>>> >>>> - Pete >>>> >>>> -- >>>> You received this message because you are subscribed to the Google >>>> Groups "Ruby or Rails Oceania" group. >>>> To post to this group, send email to rails-ocea...@googlegroups.com. >>>> To unsubscribe from this group, send email to >>>> rails-oceania+unsubscr...@googlegroups.com. >>>> For more options, visit this group at >>>> http://groups.google.com/group/rails-oceania?hl=en. >>>> >>> >>> -- >>> You received this message because you are subscribed to the Google Groups >>> "Ruby or Rails Oceania" group. >>> To post to this group, send email to rails-ocea...@googlegroups.com. >>> To unsubscribe from this group, send email to >>> rails-oceania+unsubscr...@googlegroups.com. >>> For more options, visit this group at >>> http://groups.google.com/group/rails-oceania?hl=en. >>> >> >> >> >> -- >> cheers, >> David Lee >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Ruby or Rails Oceania" group. >> To post to this group, send email to rails-ocea...@googlegroups.com. >> To unsubscribe from this group, send email to >> rails-oceania+unsubscr...@googlegroups.com. >> For more options, visit this group at >> http://groups.google.com/group/rails-oceania?hl=en. >> > > -- > You received this message because you are subscribed to the Google Groups > "Ruby or Rails Oceania" group. > To post to this group, send email to rails-ocea...@googlegroups.com. > To unsubscribe from this group, send email to > rails-oceania+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/rails-oceania?hl=en. > -- You received this message because you are subscribed to the Google Groups "Ruby or Rails Oceania" group. To post to this group, send email to rails-ocea...@googlegroups.com. To unsubscribe from this group, send email to rails-oceania+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rails-oceania?hl=en.