In-Memory Database needed

3 posts, 0 answers
  1. Vitaliy
    Vitaliy avatar
    36 posts
    Member since:
    Dec 2008

    Posted 14 May 2009 Link to this post

    Hi guys

    I'm expecting slow performance problems with my data layer tests - Database Testing: How to Regression Test a Relational Database

    People often use an In-Memory Database to speed up regression tests.

    Java people often use Hibernate+HSQL combination: Testing with an in-memory Database, Unit-Testing Hibernate With HSQLDB
    Someone like H2, because it has "Compatibility modes for IBM DB2, Apache Derby, HSQLDB, MS SQL Server, MySQL, Oracle, and PostgreSQL." - H2 VS HSQLDB
    Well, it is always interesting to read news from java world...

    What could we get here in a meagre .NET world?
    And how could you help us with TOA?
    Can you include an in-Memeory database into the TOA supporting list?

    Or maybe it would be simpler to develop your own "in-Memeory database" ?
    It could be a big DataSet with DataTables mapped to the classes with the schema.
    We will not get a full SQL support, but we could prepare data in tables and check it there.
    This looks as quite enough. (At least for my issues)

    What do you think?

  2. Dimitar Kapitanov
    Dimitar Kapitanov avatar
    632 posts

    Posted 15 May 2009 Link to this post

    Hi Vitaliy,
    For in-memory database support we are planning to add VistaDB and SQLite this year, possibly Q3 release.

    As for performance (I am not sure whether this will satisfy your requirements) if the database is on the same machine as the testing framework, and you have enough memory installed to hold all the database data, it will react exactly as an in-memory database because the server will cache it in the memory. Also not having to deal with network protocols and such, means that the tests and the database will communicate on the same machine through the same shared memory.

    Sincerely yours,
    Dimitar Kapitanov
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Check out the tips for optimizing your support resource searches.
  3. DevCraft banner
  4. Vitaliy
    Vitaliy avatar
    36 posts
    Member since:
    Dec 2008

    Posted 15 May 2009 Link to this post

    Hi Dimitar,

    What can I say?
    That's great so you've scheduled it already!

    Yes, I will be happy with the DB on the same machine. And, yes the DB layer tests will not borrow too much memory.

    I would be happy with VistaDB too. It is a SQL Server compatiblity, so, I could even run SQL queries or even intract with the stored procedures !(?)!.

    SQLite library is not compatible to anything, but it is free. Well, that's fine as well.

    Many thanks!
Back to Top