How can i test my DB speed? (Learning)
- by acidzombie24
I have design a database. Theres no columns with indexing, nor any code for optimizing. I am positive i should index certain columns since i search them a lot.
My question is HOW do i test if any part of my database will be slow? ATM I am using sqlite and i will be switching to either MS Sql or MySql based on my host provider. Will creating 100,000 records in each table be enough? Or will that always be fast in sqlite and i need to do 1mil? Do i need 10mil before a database will become slow?
Also how do i time it? I am using C# so should i use StopWatch or is there a ADO.NET/Sqlite function i should use?