Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Can anyone suggest me Best Database setup.

Software Development


Reply
 
Thread Tools Search this Thread
  #1  
Old 08-06-2011
Member
 
Join Date: Apr 2011
Posts: 52
Can anyone suggest me Best Database setup.
  

I comprise a prospective project where the DB will be predictable to store 1,000,000 latest records a week. Provide for this DB will be a multithreaded application which will sprint during the night. I was speculating if someone could recommend a DB setup/product for such traffic. For illustration I am pretty confident MSSQL Express will not be up to scrape. Any help/advice would be much respected. I hope that someone will help me thank you.

Reply With Quote
  #2  
Old 08-06-2011
Member
 
Join Date: May 2009
Posts: 532
Re: Can anyone suggest me Best Database setup.

MySQL will perform this just very well - just keep your indexes accurate and optimize every your SQL queries. Don't anticipate doing some full text searches on this however. I run a DB within which one table has 20M entries. The additional tables are within the millions as well, just not as high. I have heard of people having 1B records within a MySQL DB. Another time, presently keep your indexes light (such as an ID number only), and change MySQL memory settings as required. You simply require to look at the immense expensive guys (e.g., Oracle) if you necessitate higher concurrency. 50 million rows within MySQL are OK - 50 million rows in the company of 10,000 people accessing it every at once is further challenging.
Reply With Quote
  #3  
Old 08-06-2011
Member
 
Join Date: Mar 2010
Posts: 153
Re: Can anyone suggest me Best Database setup.

A million records a week. I guess it's a very important database. Can you afford to lose this amount of information that accumulates at a rate of more than 4 million new records per month? Could easily be replaced if lost? MS SQL Express is not suitable for such an important task. Not because of the problems associated with it, but because it provides what you really need (and free versions of MySQL not so much). If I was working with those volumes of important data that would not leaving a single database would be looking for a cluster solution with robust real-time replication between database servers, automatic failover, and a copy extremely reliable security system emergencies.
Reply With Quote
  #4  
Old 08-06-2011
Member
 
Join Date: May 2009
Posts: 525
Re: Can anyone suggest me Best Database setup.

I disagree with this. MySQL can easily scale to millions of records per week. Apart from that we do not know what a record is made of. If there are three columns in a table then anything could handle it. If hundreds of columns are then probably going to be some of the most important hardware requirements, no matter what DB you are using. In a fraction of the cost of MSSQL or Oracle, MySQL can do just about anything a business needs. It is compatible with several clusters and distributed systems. Using versions of Google or Percon dramatically increases performance.
Reply With Quote
  #5  
Old 10-06-2011
Member
 
Join Date: Apr 2009
Posts: 567
Re: Can anyone suggest me Best Database setup.

You did not mention what type of hosting environment you are using. I agree that the database design is one of the most important elements to consider. Having said that the second is the type of hosting plan you are. If I had the option I would go with MSSQL where I could go to Server Management Studio and maintenance plans of the installation, backup, replication, integration etc. It all comes down to budget. MySQL will probably do what you need, but if I could choose I would go for MSSQL.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Can anyone suggest me Best Database setup."
Thread Thread Starter Forum Replies Last Post
Suggest Me a build. i7920 based dual monitor setup laughingbuddha Operating Systems 5 27-07-2010 12:29 PM
Setup database server shane210585 Networking & Security 8 12-03-2010 04:52 PM
Creating Database link in database Lachlann Software Development 3 28-01-2010 01:17 PM
convert filemaker pro database to access database Czack MS Office Support 3 15-04-2007 01:06 AM


All times are GMT +5.5. The time now is 06:26 AM.