[login to view URL] Table Load Performance Optimization Code Fragment Needed
$500-1000 USD
Pagado a la entrega
We have a working ASP.NET web application that is built on a multi-tier data abstraction model that works fine for small data sets (less than 100 records). When a query is returned from a SQL Stored Procedure call with more than about 200 records, the entire system slows to a crawl.
This is due to the fact that the data is called in the following way:
Stored Procedure-->SQLClient DataReader-->Interate to DataTable
The problem appears to be that when the DataReader is iterated and a DataTable is created on the fly, the loop to create DataRows and takes a prohibitively long time (up to 2 minutes to create about 400 records from a DataReader).
This won't work for obvious reasons.
I need help with a better algorithm -- BUT I need to maintain the same sort of data abstraction layer and don't want to hard code any formatting in the stored procedure. That is, I need to be able to create DataRows or something like them in code.
Please see the attached file for an example of the current working but slow code fragment and feel free to ask questions.
Thank you.
## Deliverables
1) Complete and fully-functional compile-ready source code for all work done.
2) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
Windows 2003 Server
IIS 6.0
ASP.NET 2.0 Framework
VisualStudio 2005
SQL Server 2005 SP2
Nº del proyecto: #2947943