Re: I can attach in SQL Server, but can I in Oracle?

Ron Fluegge wrote:

> One of my larger clients has 280 generating units and they have only
> generated about 300,000 data records in 21 years of collecting this data --
> that's total; so it averages about 50 records per unit per year (some units
> will collect as many as 500-600 records in a calendar year). So while
> scalability is a concern, it is a smaller concern than the AA example.

Seems reasonable. The problem description does appear to fit into the small subset of problems that can likely be solved - and stay solved - with a 'database indenpendance framework'. Sadly, as you've noticed from 'our' reaction, that is not generally true.

In normal Oracle circumstances the 300,000 records could possibly be handled by in-memory cache. Not knowing the app, I'd guess your total memory requirement for the data will be roughly 45M. Given the Oracle installer demands a minimum of 256M, and given there are 1-2 users, I'd say scalability issues are somewhere between non-existant and zero. Received on Sat Aug 09 2003 - 22:39:06 CEST