Well, in fact it is the table that is kind of the heart of it all. And there surely will be some other tables depending of it, but there probably won't be serious traffic between them and complex is really not the right word for that. But when others handle millions of entries I will be able to make it with a few thousands, huh? ;) We're gonna see.
Thanks for the quick reply, Freddie! Karsten -----Ursprüngliche Nachricht----- Von: Freddie Sorensen [mailto:[EMAIL PROTECTED] Gesendet: Samstag, 15. Mai 2004 19:29 An: [EMAIL PROTECTED] Betreff: AW: How big is big? Karsten, I wouln't worry about this - There are plenty of examples where people are running tables with millions of records without significant performance problems. Of course it all depends on the complexity - will you have many tables and many joins in your queries ? Just make sure to index your tables properly Freddie > -----Ursprüngliche Nachricht----- > Von: KingKarsten [mailto:[EMAIL PROTECTED] > Gesendet: Samstag, 15. Mai 2004 19:19 > An: [EMAIL PROTECTED] > Betreff: How big is big? > > Aloha! > > I want to create a date table which will get about 2 thousand entries > per year and should easyly handle 10 years, which means about 20.000 > entries. > Is that realistic? Or shall I reorganize my database? > Where is the border of too many entries and MySQL gets slow? > > Thanks for your help, > Karsten > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
