Database question

[Alexx]

What's the most amount of tables you have ever used in a database for a project? And if it ever got to a point where you had so much it would lag or along those lines.

Personally I have never had more than a handful of them..but every time I try asking about it I can never get a straight answer - figured someone here would know

[hallsofvallhalla]

you will never get a straight answer but my professional answer is you will never make enough. SQL is so friggn powerful. There are SQL databases out there that hold millions of entries and hundreds and even thousands of fields and tables. You would be incredibly hard pressed to max one out as a indie dev. I would say you would not see the difference between 100 tables and 10 tables in the type of games we make.

AS LONG AS YOU INDEX!!! Make sure you properly index your tables. Always define an index if you know the table will be searched a lot.

[Alexx]

Thanks, you covered everything I was curious about