[login to view URL] Table Load Performance Optimization Code Fragment Needed

Completado Publicado Apr 30, 2007 Pagado a la entrega
Completado 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

.NET ASP Ingeniería MySQL PHP Arquitectura de software Verificación de software SQL Web Hosting Gestión de páginas web Verificación de páginas web

Nº del proyecto: #2947943

Sobre el proyecto

6 propuestas Proyecto remoto Activo May 1, 2007

Adjudicado a:

SebastianSDS

See private message.

$637.5 USD en 10 días
(129 comentarios)
7.8

6 freelancers están ofertando un promedio de $517 por este trabajo

RaiseSolutions

See private message.

$680 USD en 10 días
(31 comentarios)
7.4
ameristar

See private message.

$425 USD en 10 días
(3 comentarios)
4.5
kamranattari

See private message.

$425 USD en 10 días
(8 comentarios)
4.1
vw407490vw

See private message.

$425 USD en 10 días
(18 comentarios)
4.0
ccvin

See private message.

$510 USD en 10 días
(5 comentarios)
3.9