Jump to content
  • Advertisement
Sign in to follow this  
jen6677

How do you know if a Database will scale? (example)

This topic is 4979 days old which is more than the 365 day threshold we allow for new replies. Please post a new topic.

If you intended to correct an error in the post then please contact us.

Recommended Posts

I have a table in a DB that will be accesed often. The problem is Im unable to cluster the table on the field that Im searching for and in order to perform the query the DB has to scan the entire table. Lets assume that this table will grow to include a million records. Is this going to be a problem performance wise? Is it safe to say that you cant have an "enterprise" level app with the above schema?

Share this post


Link to post
Share on other sites
Advertisement
Is there a reason you can't try this out?

Try generating over a million records then running your query and seeing how long it takes. There should be some sort of profiling functionality available that allows you to measure how long it takes to execute a query fairly accurately.

Share this post


Link to post
Share on other sites
Sign in to follow this  

  • Advertisement
×

Important Information

By using GameDev.net, you agree to our community Guidelines, Terms of Use, and Privacy Policy.

We are the game development community.

Whether you are an indie, hobbyist, AAA developer, or just trying to learn, GameDev.net is the place for you to learn, share, and connect with the games industry. Learn more About Us or sign up!

Sign me up!