Huge table data

Question

i created an application(ASP.Net) and i use database(SQL server) for my project,it running good,but i need to check more data for performance based issue.

i used four tables like Users_Details,stock_Details,Product_details,Sales_Details,etc..
please guide me where i get more data contain a table or any sample database.

Mahesh Chand · Answer

For performance you need to make sure a few things. Make sure database is normalized Make sure you do not get too much data in the application. Get only data you need. For example if you need 100 rows just get 100. Do not get all. In SELECT queries do not use SELECT *. Give columns names Count using stored procedures Use Stored procedures. Do not use inline SQL queries And the list goes on. Work on these first :) Good luck!

Suthish Nair · Answer

Best use your own tables with bulk data insertion.