Re: System Scale Up Advice Needed

[This followup was posted to comp.databases.theory and a copy was sent to the cited author.]

This one time, at band camp, <3a18dc6a_at_grissom>, plfitzge_at_powerup.com.au said...
> System Scale Up Advice Needed
>
> We have slowly evolved a business system using MS access and as the backend
> tables are getting larger (300-400mb) with more users on line (8-12), we are
> finding that access is running out of puff and is increasingly erratic.
>
> We wish to keep the same front end and link to a stronger backend to allow
> for more users
>
> The current system is.
> Access 97 running 195 tables, 858 Queries, 506 Forms 450Reports, 80+
> Macros & Modules
>
> Backend 300-400mb on a 350mhz Celeron server, 64meg ram 4 gig drive
>
> 12PC's from 120mhz P1 to 666mhz Celerons
>
> 10/100 switched hub
>
> The required parameters are.
> LOWEST COST Possible, the man who owns the business had ONE 386
> computer doing the books
> with a DOS accounting system for FIVE years before we started and NT /
> SQL-7 is not an option.
> I cannot justify 10's of thousands.
>
> Able to scale up to a 3-4 Gig backend, even in its current form it is
> doubling in size every year.

Okay. First of all (making some assumptions about the skill, knowledge and ability of your in-house development people), SQL Server 7.0 would probably be your best bet for success, given your other parameters. Alas, if the funds aren't there...

Failing that, you might consider MSDE. Its free, and could deliver a "SQL Server-like" back end.

Check out: http://www.microsoft.com/DirectAccess/feature/99/0224.asp

MSDE does have a 2gb database size limit.

Other solutions might be found in some of the open-source database servers like MySQL, PostgreSQL, or InterBase. Received on Mon Nov 20 2000 - 18:34:46 CET