Hi, i've developed a Windows application which accesses a large database
around 11 million records. Currently i'm using MySQL as the database
server.
All is ok except that this application is supposed to be installed by the
app users who may not really know how to install a database server. From
my
experience, 1 in 5 of my app users have been re****ting problems
encountered
during MySQL server installation or configuration. Especially with Windows
Vista that makes copying and replacing files more difficult. Firewalls
also
have been found to be one of the culprits.
It would be great if i could use Access because then i can just ****p the
..mdb file together with my app without needing to install any database
server. However, the size of the database file which exceeds 2G limit
means
that i cant use this option.
So now i'm still looking for a better alternative database for my use.
Something which is ok in performance and especially easy to deploy by the
user. These are some of my options:
- SQLite
- Interbase
I havent considered any of these in detail but SQLite seems quite good and
it can be used as a data file instead if client-server.
Any comments on Interbase? i'm not too familiar with it..it is said to be
an
embedded database..just what really does that mean? is it like a data file
also?
Any other suggestion would be most welcome.
