|
-
Jun 17th, 2004, 08:49 AM
#1
Thread Starter
Frenzied Member
Can you Query DataTables?
Obviously you can fill a datatable from a query. Is it then possible to query that result set. I am tied into a really crappy old RDB database that only has access via ODBC. I'm working with maybe 5 or 6 tables. When I pull a whole table over, it takes maybe a minute for 150,000 records. Then however I have to use keys from that first table to query the other tables for data to build a complete dataset. To build a complete "record" for each of the 150,000 records in the first table, it takes over two hours. Can I just pull over all the records (so about 6 or 7 minutes), and run queries against them right in the Datatable, or do I have to dump them back to a SQL Server database or something?
Sean
Some days when I think about the next 30 years or so of my life I am going to spend writing code, I happily contemplate stepping off a curb in front of a fast moving bus.
-
Jun 17th, 2004, 08:52 AM
#2
Thread Starter
Frenzied Member
Ok, nevermind, I see it.....
Sean
Some days when I think about the next 30 years or so of my life I am going to spend writing code, I happily contemplate stepping off a curb in front of a fast moving bus.
-
Jun 17th, 2004, 09:41 AM
#3
Frenzied Member
I'd see if there was a way to select fewer records in the first place.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote