Hi!

I have a very simple project, just taking dummy orders from customers. The system uses
only two (2) tables, order_header and oreder_line, all data are dummy, there are no
customer or product tables to join, user append the data manually.

The 1st problem is that there is a huge amount of records, counting about 2.000-2.500
records daily, from a 4-user network.

The 2nd problem is that they need many statistic reports.

Suppose we an average 2.200 transactions per day and 250 working days a year, we get a
huge number of 550.000 transactions per year; transactions that we need to access to our
statistics reports.

Can DBISAM stand this huge amount of -simple- data, or should I look for another database
system? (SQL Server MSDE perhaps)

Thank you in advance,
Stratos Nikolaidis
Thessaloniki, Greece

Stratos,

<< Can DBISAM stand this huge amount of -simple- data, or should I look for
another database system? (SQL Server MSDE perhaps) >>

Sure it can handle it fine, we have users using tables with 25+ million
records.  I would suggest, however, that you use the DBISAM database server
in order to avoid any issues with corruption if someone shuts down one of
the client machines while working in one of the tables.  DBISAM can repair
the tables, but with tables that large it may take more time to repair than
you're willing to tolerate.

--
Tim Young
Elevate Software
www.elevatesoft.com

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:

<<Sure it can handle it fine, we have users using tables with 25+ million
records.  I would suggest, however, that you use the DBISAM database... >>

Thank you for the answer. I will follow your suggestion and I'll use the DBISAM Database
Server.

Stratos Nikolaidis
Thessaloniki, Greece