Database Size ?!!

ab4net

Dear All,
i have a project, contains a database "MySQL" for Prepaid Cards.
it contains till now a 30,000 Row, is there a size ..?
or i can just go ahead to reach the 1000000 row ..?

if any one can help me in the databases size, iam greatfull 🙂

many thanks in advance,

nemonoman

Assuming you have a fairly well designed database, and a reasonably capable server, you should be able to manage a million rows in MySQL with little or no degradation in performance.

Because you are asking this question, however, it makes me think that you may not have had a great deal of database experience.

I would suggest therefore that you get somebody with some good database experience to take a look at your database design to make sure that it will scale up effectively. You might also look into books and articles on database normalization. Normalizing your database design will definitely improve your chances for good performance.

ab4net

Thank alot for reply,
i knew that database got milions of rows in it,
and its doing well now in performance, but some of my friends who works on ORACLE told me that MySQL got crazy after 30,000 rows .. i told him, may be u did not manage the database stucrtue well, but he insisted.
therefor i asked the question ..

thank you alot ..

if you recomed a URL of course i'll read ..
many thanks again ..

AstroTeg

I've got a web log MySQL DB that has 6 million rows in it (for the entire database). There's 2 tables which have 2 million rows in them, although I don't query those tables directly. They are used to produce summary tables which end up holding anywhere from 20000 rows to 100000 rows. Query times on these tables are usually pretty quick - within 1 to 6 seconds depending on what you're asking from it.

If you spend some time on database and application design, 100k rows shouldn't be a big deal.