ADO.NET question

  • Thread starter Thread starter JuLiE Dxer
  • Start date Start date
J

JuLiE Dxer

I can't seem to figure out which newsgroup I used to follow that
pertained to ADO.NET...

anyways,

Is there a best method to programmatically update large DataTables
into an Access DB file for efficiency? Larger DataTables seem to take
quite some time to write to db file.

MsJuLiE
 
JuLiE Dxer said:
I can't seem to figure out which newsgroup I used to follow that
pertained to ADO.NET...
Click to expand...

microsoft.public.dotnet.framework.adonet I suspect.
anyways,

Is there a best method to programmatically update large DataTables
into an Access DB file for efficiency? Larger DataTables seem to take
quite some time to write to db file.
Click to expand...

Well, rather than using a DataAdapter, you could try building the
appropriate SQL statements yourself, batching them up. (DataAdapter
doesn't do any batching currently; in ADO.NET 2.0 it will.)
 
Hi MsJuLiE (Miss July? :P)

There is a microsoft.public.dotnet.framework.adonet group, which might be
what you were seeking.

This group isn't exactly wrong, but vb people might not read this group.
The specific adonet group might be better.
 
vb ?

I'm wondering if verizon carries this group, I didn't see it on my
list.

I can easily manage the SQL part of the issue. I thought I remembered
reading about a particular method of updating a database being better
than other ways through C# / ADO.NET.
 
JuLiE Dxer said:
vb ?

I'm wondering if verizon carries this group, I didn't see it on my
list.

I can easily manage the SQL part of the issue. I thought I remembered
reading about a particular method of updating a database being better
than other ways through C# / ADO.NET.
Click to expand...

Why not just set up another news account at msnews.microsoft.com? That way,
you'll get the groups you want/need direct from the "source".
 
JuLiE Dxer said:
vb ?

I'm wondering if verizon carries this group, I didn't see it on my
list.

I can easily manage the SQL part of the issue. I thought I remembered
reading about a particular method of updating a database being better
than other ways through C# / ADO.NET.
Click to expand...

Hi,

ADO.NET doesn't do any magic in this sense - it fires sql statements and
that's it.
Your only option is to tweak sql statements.
 
I'm basically just reading a log text file with <delimited> tags
followed by the tag's value and put each log entry into a row into a
database. Basically, inserts.. It works, of course, but can be very,
very slow when inserting 10,000+ rows. Perhaps, this is just a
necessary time factor, eh?
 
Back
Top