Huge table data in SQL server or Oracle

Posted by Jayakumarv under Sql Server on 2/28/2011 | Points: 10 | Views : 963 | Status : [Member] | Replies : 3
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.




Responses

Posted by: Krkc on: 2/28/2011 [Member] Starter | Points: 25

Up
0
Down
If you are displaying your records in a Grid, then I suggest you start using PAGING.

Using ObjectDataSource with Paging is a good solution for displaying N number of records with optimized performance.

Thanks,
Ravi

Jayakumarv, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Prabhakar on: 2/28/2011 [Member] [MVP] Starter | Points: 25

Up
0
Down
Hi Jayakumarv


i think u you join your gridview to northwind database or MASTRE database . . in such table have more records.. u try . .fill ur grid . .

Best Regard's
Prabhakar

Jayakumarv, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Madhu.b.rokkam on: 2/28/2011 [Member] [MVP] Bronze | Points: 25

Up
0
Down
Just point to a inbuilt DB in your server and try to load that onto your grid.

Thanks and Regards
Madhu

Jayakumarv, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response