This question is locked. New answers and comments are not allowed.
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?
Thanks
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?
Thanks
2 Answers, 1 is accepted
0
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.
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.
0
Vitaliy
Top achievements
Rank 1
Rank 1
answered on 15 May 2009, 08:28 AM
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!
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!