469,344 Members | 6,527 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Dataset search performance question

Am relatively new to .NET and am trying to use it to create a usage
billing system that can process a million or two records each day. Am
currently using a simple system written in C that uses hash tables to
look up all the information necessary to bill each record.

My question is, If I use a DataSet to maintain all the various lookup
tables involved in billing each record (some are small, some have
100,000 records), can accessing records out of these tables be as fast
as using simple hash tables in memory? Are indexes in the datasource
migrated and used in the DataSet?

Are there other less obvious tips/tricks for getting the fastest
possible search access out of DataSets?

Thanks for your advice.

Jeff
Jul 21 '05 #1
1 1423
No. (I don't think datatables will be as fast as hashtables, plus the
memory overhead is going to be huge) Although even a hashtable is not
too good, you can consider using a BST for your lookup table.

http://msdn.microsoft.com/library/de...res_guide4.asp

No., indexes are not copied from the datasource.

Sijin Joseph
http://www.indiangeek.net
http://weblogs.asp.net/sjoseph

Jeff Wilson wrote:
Am relatively new to .NET and am trying to use it to create a usage
billing system that can process a million or two records each day. Am
currently using a simple system written in C that uses hash tables to
look up all the information necessary to bill each record.

My question is, If I use a DataSet to maintain all the various lookup
tables involved in billing each record (some are small, some have
100,000 records), can accessing records out of these tables be as fast
as using simple hash tables in memory? Are indexes in the datasource
migrated and used in the DataSet?

Are there other less obvious tips/tricks for getting the fastest
possible search access out of DataSets?

Thanks for your advice.

Jeff

Jul 21 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

28 posts views Thread by joshc | last post: by
4 posts views Thread by Oscar Thornell | last post: by
4 posts views Thread by Bas Hamer | last post: by
2 posts views Thread by Carl Summers | last post: by
reply views Thread by Jeff Wilson | last post: by
1 post views Thread by # Cyrille37 # | last post: by
4 posts views Thread by =?Utf-8?B?V2lsc29uIEMuSy4gTmc=?= | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.