469,903 Members | 1,398 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,903 developers. It's quick & easy.

Basic data processing question

I am in the process of writing the middle tier for an application. This application will grab records, runn them through a process and save them in a table. In going through this process I'll have a staging table from where I grab the records before they are analized and saved into the history table. There is no telling how many records there will be in the staging table for processing, but potentially it could be in the thousands (or at least I would like to be prepared for that many records from a performance stand point)

My question is performance wise, do I use arrays to load all the records for processing or do I just parse through a recordset? My guess would be that arrays are much faster than recordsets because you have the database connectivity issue, but I still have the issue of loading the working array from the staging table.
Nov 20 '05 #1
2 1086
Danny:

Why not just use a Dataset with multiple datatables?
"Danny A." <an*******@discussions.microsoft.com> wrote in message
news:A4**********************************@microsof t.com...
I am in the process of writing the middle tier for an application. This application will grab records, runn them through a process and save them in
a table. In going through this process I'll have a staging table from where
I grab the records before they are analized and saved into the history
table. There is no telling how many records there will be in the staging
table for processing, but potentially it could be in the thousands (or at
least I would like to be prepared for that many records from a performance
stand point).
My question is performance wise, do I use arrays to load all the records

for processing or do I just parse through a recordset? My guess would be
that arrays are much faster than recordsets because you have the database
connectivity issue, but I still have the issue of loading the working array
from the staging table.
Nov 20 '05 #2
Would that be faster than arrays? I guess I have the idea (maybe erroneous) that recordsets are more resource intensive than arrays that are already disconnected from the database.
Nov 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by bjam | last post: by
7 posts views Thread by gerryLowry::Ability Business Computer Services {KC | last post: by
4 posts views Thread by CSharpguy | last post: by
6 posts views Thread by JimmyKoolPantz | last post: by
7 posts views Thread by =?Utf-8?B?R3JlZw==?= | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.