Recomendation for search-software

[RadjeshNL]

Hi,

2 years ago I created software (VB6) that searches according a name. As for a database I used Access(*.mdb). The software was installed local.

Now I have VB2008 Pro and was wondering would it be better to use a SQL database? If so... Can I install the software local and will the SQL also be installed or do I have to install SQL on every computer seperate.

BTW: What book do you recommend about learning SQL?

Thanks in advance.

 

[RiverGuy]

Well what does your database do? If you need a robust database system, then you might look at SQL Server Express. However this installs a database engine service on the user's PC. If you just need to store a few records, you might look at SQL Server Compact. This is run only in memory by referencing a .dll, although it does not have as many options as SQL Server proper. You cant do some types of queries or create views for example. You can also look at SQLite, or stay with Access.

 

[RadjeshNL]

Thanks for the reply RiverGuy.

I use(d) 8 seperate tables which contains about 2,000,000 records, (highly) probably more.

When the user opens the software it loads only what needed from a table in 2 seperate comboboxes. When typing in the combobox the records, according the suggested "value", are shown in textboxes. Which means that the connection "stays alive". (No connection.close)

I hope you understand what kind of software it is.

 

[RadjeshNL]

No one?

 

[RiverGuy]

Just try some of your options. I would be hesitant to do 2,000,000 rows in an Access database, but you might get some other feedback from Access developers in one of the Access forums. I haven't tried a non-server db with that many records either (such as SQL Server Compact or SQLite). SQL Express should work just fine, however the one drawback you face is that it installs as a service on the client PC.