File Sizes

[DanS]

OK, I have flat-text databases worth 78.6MB (don't all cringe at once).

Assuming I added indexes (doesn't MySQL require one for each table?), what would the total file sizes be (v. roughly)?

Would adding this size of database kill FutureQuest's server?[nbsp][nbsp]I suppose I could scale it down...

[Terra]

That is a very dynamic question with no easy answer...

It all depends on the field types selected and if they will be variable or not...

With a 78.6Mb dataset, (don't hold me to this!) I would say with indexing could drive it upwards of 100Mb...

MySQL can handle that size easily if proper indexing is done...[nbsp][nbsp]One of my Alpha projects (Logs/Stats) is working with a 16Gig dataset of information and grows around 575Mb a day generated by 5 of our largest domains...

You can find more information on tweaking your tables, indexes, and schema at:
http://www.mysql.com/Manual_chapter/manual_Performance.html#Table_efficiency

You have a choice to make - speed and/or compactness...[nbsp][nbsp]The above logfile project is a mixture of both...

--
Terra
--Logs and Stats are going to be the death of me one day--
FutureQuest

[DanS]

Thanks for that chapter.[nbsp][nbsp]I checked the manual earlier, but must have missed it...

>One of my Alpha projects (Logs/Stats) is working with a >16Gig dataset of information and grows around 575Mb a
>day generated by 5 of our largest domains...

OK, I suppose my project is small potatoes compared to that :)