What database software to use. 3

[touregg]

What if i was going to create a database to hold 8 million records, with about ten fields each. A front end would be created for this database with about 25 users. What database software would best fit this use?

 

[SteveR77]

I would recommend Oracle because of the flexibility the solution would give you for the future.

If cost is an issue than I would tell you to look at Sybase and then MS SQL Server.

Front ends can be built for all these databases once you have the solution in place.

HTH,

Steve

 

[CajunCenturion]

What is your budget, and what do you already have on hand?

Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein

 

[zemp]

Another database to consider might be MySQL. You can check out their website.

http://www.mysql.com/

Take Care,

zemp

"If the grass looks greener... it's probably because there is more manure."

 

[touregg]

thank you very much all is helpfull. I'm not sure that mysql would be able to handle that many records with the speed im looking for, but other than that i am a big fan of mysql. I'm working on a project right now, and it's kind of a sisuation where were oftered out side assitance but the company wants me to find out if we can create something in house for less. We already have to spend $25,000 as it stands but im not sure what the limit would be. I would image another $25000 would probley be the limit but dont know at this point. The cheaper i could go the better i would look. but the performace has to be there.
Any thing else any body can add?

 

[oharab]

I can't see MySQL having a problem with that sort of size! From what I have been told, it's pretty good at handling large databases and is reckoned to be one of the fastest dbms out there.
Don't be put off by the open sourceness of MySQL, it's serious stuff!

Ben

----------------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

"Where are all the stupid people from...
...And how'd they get so dumb?"

NoFX-The Decline
----------------------------------------------

 

[touregg]

Really? Well maybe i stand corrected. do you have a site or anything were i could read about Mysql's performace?

 

[SteveR77]

Here you go -

http://www.linux-mag.com/2001-12/mysql_01.html

http://www.mysql.com/newsletter/2004-01/a0000000301.html

 

[skiflyer]

I always like to point out Slashdot when people talk about MySQL and size/performance...

http://www.mysql.com/press/user_stories/slashdot.html

http://krow.net/talks/mysql_slashdot_scaling/

 

[sem]

You may use Oracle SE. Its price is quite reasonable and it provides all main Oracle features. Then if your application will need higher capacity you may easily migrate to EE.

Regards, Dima

http://seminihin.narod.ru

 

[multiplex77]

I've seen for myself how fast MySQL is.

http://www.gospelcom.net

contains over 17 translations of the Bible and the searches are still lightning fast. Last time I checked they told me they use MySQL.

But is there any GUI interface for MySQL, similar to MSSQL Server or Access? The ones I've tried out seem to be inferior and that's my biggest holdup when it comes to using MySQL.

Anyone have any comments on this?