2006/5/30, Harish TM <harish.tmh / gmail.com>:
> hey thanks a lot
> Guess MySql is fine
>
> about the Ruby part I am using: mysql-ruby1.4.4a   is that ok? Or are there
> better ways of doing this?
>
> I need an access time of about 0.05 sec. (record retrieval time)

Usually the DB is the limiting factor and not the app.  Whether 0.05s
is tight or not depends on a number of factors including but not
limited to DB vendor, IO subsystem, volume of data, indexing etc.

> System config:
> Processor: Dual Processor Intel Pentium (P4) 2.53 GHz
> Memory RAM: 4 GB
> HardDrive Capacity : 250GB
> Operating System: SUSE Linux Enterprise Server 9

I suggest you make some performance tests with typical data.

Kind regards

robert

-- 
Have a look: http://www.flickr.com/photos/fussel-foto/