SATA drive ?

[Net Llama!]

On Mon, 27 Sep 2004, Vu Pham wrote:
> Thanks again. I should have given more details.
>
> I am converting a Interbase/Firebird database to Oracle. This IB database
> has 5 tables, and the two biggest ones has about 90K and 200K records, each
> about 300 bytes. The users are about 150 "remote" users. They all use PDAs
> with slow connection ( less than 8 kbps )  to access to the system for
> searching only. They only send a shot criteria of what they want to search,
> and a frontend app on the IB server makes the search, and send the result
> back to the users. Every midnight, there is a cronjob that imports ( ftp )
> text data file from a remote system and update to the database.
>
> Another customer wants to have a similar system, and I would like to build
> to a pilot system on Oracle with only a small part of the current systems
> like 10K of records, and 5 requests at one time, every 30 seconds.
>
> I have almost no experience on Oracle ( I know a little bit on how to create
> Oracle databases, create and assign users and their permissions, and some
> common SQL ) , and I believe this process will require me to install Oracle
> many times ( for training myself ), before I can do any serious development
> on the system.
>
> That's why I think of something not so slow so that I can save time when
> doing those installations. And because this is a pilot system, not so much
> budget is allocated for it.

All of this begs the question, why are you choosing oracle?  Is there
specific Oracle functionality that you need?  Or why are you not using
Firebird?

I wouldn't wish Oracle on my worst enemey.  Ok, maybe i would, but i
certainly wouldn't recommend it to anyone else.  Its a maintanence
nightmare, suport is honestly the worst I've ever experienced, and its a
huge pig when it comes to resources.

So unless you have a hard requirement to use oracle, i'd certainly
recommend against it.

-- 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Lonni J Friedman                                netllama at linux-sxs.org
Linux Step-by-step & TyGeMo                  http://netllama.ipfox.com