Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

IF we have lot of records in Database. How we can handle them?

Answer Posted / pavan kumar p

You can handle Large data by practicing some design
patterns like, using stored procedures rather than
Statements, Use coloum names rather tahn * when fetching
the statements etc..

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the uses of Stored Procedure?

1067


Does executenonquery return a value?

958


What is the use of adodc?

992


What are datareaders?

983


What is an orm, and why would you use one instead of plain old ado.net?

1052


Explain the DataAdapter.Update() and DataSetAcceptChanges() methods.

1019


How to check if a datareader is closed or opened? IsClosed()

1031


What is ado.net tutorial?

950


If a table contains 20000 records. In a page at each time 100 records to be displayed.

892


What is difference between sqldatareader and sqldataadapter?

931


What is ole word?

952


What are the ado.net connection pooling parameters?

983


How to copy the contents from one table to another table and how to delete the source table in ado.net?

1039


Explain the difference between sqlcommand object and command behavior object?

1092


What are the data providers in ADO.NET framework?

1032