Hello.
My company is planning on setting up a database for its operations.
However, the database itself will not be accessed very often. It will
sit on a Dual PIII-1.2ghz box with 1024MB RAM, and of course some nice
SCSI HDs.
The databases will grow quite large, as they will be a centralized
store of all company transactions such as gift certificates,
purchases, etc. There are only roughly 30 locations in all, and remote
updates to it will be somewhat infrequent. Queries will be even less
frequent and extremely simple in logic.

So my question is, must I really suggest that we go the extremely
expensive route of Microsoft SQL? *nix SQL or other brands of it in
general wont really work, as this company has a bad habit of choosing
MS only products.

Would Access databases be sufficient for this sort of load? Because
despite the infrequency of database accesses (maybe 100 between
updates/queries a day average), they will grow quite large in time.

Anyway, thanks for any input

Chuck

Forestfish schrieb:
Linux/PostgreSQL. Very reliable combination and not expensive at all. You a
small amount for the Linux distribution and nothing for the PostgreSQL database.

If you are concerned about support, there are comapnies giving professional
support for PostgreSQL.

MSDE might be an option (as Neb suggested), I haven't really used it with more
then one user, but basically I'm kinda reluctant towards using MS SQL (personal
opinion!)

You might consider using MySQL as well. After all a lot of large and heavily
used databases are implemented in MySQL. But look closely at the features, there
are some of the "normal" RDBMS features that MySQL lacks (or will get in a later
release). But from your description it seems that it might be sufficient.

I don't know what your programming environment is, but one of the free Java
databases like HSQLDB might be an option as well (though I'm not sure how it
will perform in a 24/7 environment)

Regards
Thomas

Hi!

"Bob Hairgrove" <rhairgroveREMOVE (AT) THISbigfoot (DOT) com> kirjoitti viestissä
news:3f315ca1.1924887 (AT) news (DOT) webshuttle.ch...
MySQL has supported transactions for 3 years now.

Best regards,

Heikki Tuuri
Innobase Oy
http://www.innodb.com
Transactions, foreign keys, and a hot backup tool for MySQL