[RESOLVED] Recommend a DataBase host/server

[Jim Davis]

Hello!

I need some experienced people to help me out to find the best solution. Im looking for any Database solution that could run on low resource machines (eg 32-64 mbytre ram, win98 (native/se), p2/celeron). I love to use the SQL like query language, that could speed up my work...

Please post here your recommendations, and some link to see more information about usage and/or installation of it.

Thank you very much
J

[Hack]

MySQL seems to be pretty popular.

[Jim Davis]

Thank you, but i already know about mysql, ive used it in a few projects in the past. It works ok, but it uses a bit high amount of resources (around 40-50mbyte of VM and another 10-20 mb of PM on my winxp, not tested under win98)

Is there any other alternative that uses less resources?

edit: i forgot to say that i have to run the server locally, theres no any network connections available!

[corwin_ranger]

If you're running the app and database locally, then perhaps Access would be a good solution. You don't actually need Access installed on the PC where your app is running since your application will be working directly with the database. It's fairly low in terms of resources (i.e., no additional services). I'm not sure of the specific requirements, but asside from MySQL, I can only really think of MS MSDE or SQL 2005 Express.

Steve

[Jim Davis]

umm Thanks!

Access is a good point, but what about MS Sql Express? How many resources it takes, and what about the stability/speed? Some experiences would be nice!

Thanks
J

[GaryMazzone]

SQl Express requires .Net 2.0 Framework and is not available for Win98

[corwin_ranger]

I can speak a bit to MSDE (essentially SQL 2000 Express) as an option . I didn't write the application invloved here, but was part of the implementation. The initial recommendation for the system requirements was a PII or Celeron with 128MB of memory. After loading the application on existing systems (which met these minimum requiremtns), they ran like pigs. They ran this way even when the app wasn't loaded, which suggests to me that MSDE was the primary culprit. Now, we didn't examine specic memory usage, etc.

Steve

[Jim Davis]

What about SQLite? Officially its not available for Visual Basic or Coms, only driven by C/C++ but theres a few wrapper thingie that helps to use it under vb.

http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers

Have somebody any experiences about sqlite?
Thanks

[Jim Davis]

http://www.tannertech.net/dev/sqlite3vb/

Wow SQLite (wrapper) was impressed me, it looks like this is exactly im looking for. It has all of the mayor functionality, theres no need to install, because everything is encapsuled in one small dll (about 400K). And theres no additional dll dependencies. So its easy to deploy with my project...

Heres the list of the syntax: http://www.sqlite.org/lang.html

Ive just developed a little class that uses the SQLlite wrapper. Class attached.

Then ive did some testing by using my class. Massive data storing:
Insert statement, 7 columns, integer and text columns with variabled length.
7400 row.. and it stores it all around 12-13 minutes!!! its very cool i think so.

Then this btch just reads all back less than a half of a second.

Well.. SQLlite is for small projects, like tools or locally used programs. But it looks cool.