very slow oledb insert to Access - any advice?
within a loop i am building a sql insert statement to run against my
(programatically created) mdb. it works but it seems unreasonably SLOW!
Sorry, dont have the code here but the jist is very standard (I
think!);
e.g:
# get connection
loop
{
build sql (35 fields to insert)
call ExecuteNonQuery on command obj associated to connection.
}
# close conn.
the insert is called about 500,000 times and that is proving very
time-consuming (e.g. about 15 minutes!!!!)
no exception is thrown and all records get inserted. i cant see any
prob save the dire performance. am i expecting too much or is there a
better perfoming solution (and i wont laugh if someone replie with
'SqlServer' or 'Oracle' as a solution... ;-)
cheers. dan
.
Relevant Pages
- c# oledb - multiple inserts to access (mdb) VERY slow - help!
... within a loop i am building a sql insert statement to run against my ... dont have the code here but the jist is very standard (I ... call ExecuteNonQuery on command obj associated to connection. ...
(microsoft.public.dotnet.languages.csharp) - Re: newbee needs help with code
... I must assume that the connection being used by DataReader3 is not ... > As you can see the code inside a while loop will generate a different SQL ...
(microsoft.public.dotnet.framework.adonet) - Re: Concurrent database access in SQL 2005 Mobile
... Please stick to having an "dummy" connection in Open State. ... SQL CE/Mobile has a background thread that flushes the changes ... they run for long hours and we have not seen memory leaks so far. ... then opens his work forms and it's in ...
(microsoft.public.sqlserver.ce) - Re: Concurrent database access in SQL 2005 Mobile
... Please stick to having an "dummy" connection in Open State. ... So it is a kind of asynchronous commit which happens every 10 ... I am not sure of this claim as we have many applications built on SQL CE ... then opens his work forms and it's in ...
(microsoft.public.sqlserver.ce) - Access 2003 adp/proxy security - A substitute for SYSTEM_USER()
... We need a way for SQL to know the nt username that initiated the proxy ... Many stored procedures and views use a UDF that also depends on ... SyUserLogin and use HostIDand HostName() to find the right row. ... We've played with the Connection dialog settings, ...
(microsoft.public.access.security) |
|
