SATA drive ?

[Vu Pham]

> -----Original Message-----
> From: linux-users-bounces at linux-sxs.org 
> [mailto:linux-users-bounces at linux-sxs.org] On Behalf Of Net Llama!
> Sent: Monday, September 27, 2004 9:15 AM
> To: Linux tips and tricks
> Subject: RE: SATA drive ?
> 
[...]
> > Thanks for the suggestion. This system is a pilot system, 
> its database 
> > is small ( no more than 10,000 records ) and no more than 5 users 
> > accessing to the system at same time. How much memory is 
> reasonable in this case ?
> 
> 10k records of what kinda of data?  Is each record 1k, 1M or 
> 1G in size?
> What are you doing with the records?  Is this just simple 
> selects, inserts & updates, or are you doing fancier things 
> with Oracle specific functionality?  How many transactions 
> per second or per minute, and at peak usage?
> 
> Also, the amount of RAM in the box is irrelevant if you don't 
> tune the database to take advantage of it to coincide with 
> how you're using the database.
> 

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.


Thanks,

Vu