MySQL Forums
Forum List  »  Newbie

Database with alot of records
Posted by: Martin Jorgensen
Date: March 03, 2015 04:11AM

I have a database with 200+ million reconds in one table.

Is this manageable? Right now it is running very slow, but the server needs to be upgraded.

The table has 4 fields.
3 x Int
and 1 x varchar(100) Primary index

Do you think I can expect fast results on SQL's that search the varchar field and order by an Int field?

Options: ReplyQuote


Subject
Written By
Posted
Database with alot of records
March 03, 2015 04:11AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.