February 8, 2008 at 12:11 am
Hi,
I am working in Trade enivornment and i have experience only on SQL 2000.
Each day approximately 4 million data gets loaded and transactions being happened in my server.
Please let me know which database(Sql/Oracle..) can i use for high performance with free or one license.
I am looking for a database which is having hhigh speed in retrieving large data and having massive storage with no performance issues.
Some suggested me to use Informix, but still im doing a R&D work on it.
Please suggest me with two or three different datases with their high performance features.
Thanks in advance
February 8, 2008 at 1:13 pm
Depends. As a SQL guy, I will recommend SQL Server 2005 Std. edition as you are asking for free or one license.
I had a database which has transaction volume between 1.5 million to 2 million records daily and is working good without any issue. We are using SQL Server 2005 Ent. edition on 4 cpu 16 GB quad processor.
search documentation for Oracle 11g and it would also work good. Had no experience with Informix. so, no comments.
SQL DBA.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply