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.
Loading
Mahesh ChandPosted Feb 28, 2011, 11:33 PM
- 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 NairPosted Feb 28, 2011, 5:54 AM