|
hi
how can i load 1,000,000 records to access in the fastest way ?
i'll try:
int End = dsView.Tables["BarcodTbl"].Rows.Count;
int i;
for (i = 0; i < End; i++)
{
Cmd.CommandText = "INSERT INTO BarcodTbl(Code,Barcode,numH) VALUES('" + dsView.Tables["BarcodTbl"].Rows[i][0].ToString() + "','" + dsView.Tables["BarcodTbl"].Rows[i][1].ToString() + "','" + dsView.Tables["BarcodTbl"].Rows[i][2].ToString() + "')";
Cmd.ExecuteNonQuery();
}
but it take over 20 minutes
thanks
|
|
|
|
|
I am not sure, but try creating insert statements inside the loop and execute it after the loop finishes. So you are opening only one connection and doing bulk insert.
|
|
|
|
|
thanks for the help
can i get any sample code for this ?
|
|
|
|
|
E_Gold wrote: can i get any sample code for this ?
StringBuilder sb = new StringBuilder();
for (i = 0; i < End; i++)
{
sb.Append("INSERT INTO BarcodTbl(Code,Barcode,numH) VALUES('" + dsView.Tables["BarcodTbl"].Rows[i][0].ToString() + "','" + dsView.Tables["BarcodTbl"].Rows[i][1].ToString() + "','" + dsView.Tables["BarcodTbl"].Rows[i][2].ToString() + "')");
}
Cmd.CommandText = sb.ToString();
Cmd.ExecuteNonQuery();
|
|
|
|
|
The Sample Code is not working, whay ?
|
|
|
|
|
Do it once, then copy the Access file. If you have to insert a million records into Access regularly, then something is seriously wrong with your design.
|
|
|
|
|
I think this is impossible to solve. Access is not built to handle this amount of data. You might get it to work slightly slower, but don't expect miracles.
The solution suggested using bulk adding will use loads of memory. If you plan to use it, watch the memory usage, or split it up in chunks of 10 000 rows or something.
|
|
|
|
|
In your example the command gets parsed for each row; use a parameterized command.
Before the loop, set the command and add the parameters.
Inside the loop, set the values of the parameters and execute the command.
This way the command is only parsed once.
I also wonder why you use for rather than foreach.
|
|
|
|
|
Hi,
I am new to crystal reports ...I want to pass a string value to a field
in a report...
and a data bounded value to another field
Please tell me how to do this
Thank You
*** Why EXPERTS behave like a fool ***
|
|
|
|
|
Hi All,
I want to develop ludo board game application with following feature.
It will be a multi user application where user can play from his desktop.
One server multiple user architecture
User can play from his home,cafe or under proxy server(college campus)
whenever user do his part it should be reflected to every user desktop.
Game rules and procedure must be exists on server for security.
Wht is it?
Smart client application
Dot Net Remoting
Web Services
Pl give your comments/suggestions /example
Thanks for everything.
|
|
|
|
|
The answer to this question would be huge. There are quite a few articles available on how to make client server applications for chat etc. Maybe you should consider doing some research on your own before asking?
|
|
|
|
|
is it a bad thing inside a catch block within a while block? an example would be a catch block that skips a counter++ line if it encounters bad data.
TIA!
I am a SysAdmin, I battle my own daemons.
|
|
|
|
|
I don't see why, although I'd do the ++ at the end of teh try, and then it gets skipped by the catch
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
thanks. if i widen my try{} block though to include the counter++ i would be including more code than i should? (i.e. i only want to catch exception from the current code block.
I am a SysAdmin, I battle my own daemons.
|
|
|
|
|
The try is to protect that other code too; it means "I want to do these things, but not of there's a problem."
So, yeah, putting a continue in a catch is likely to be poor style.
Do it if a really need to, but it should not be your usual tactic.
In the case described, it's simpler to put the increment in the try rather than after.
|
|
|
|
|
It should be ok. I often find that it takes some extra time to catch an error rather than checking the data by other means. This means that if errors are frequent you might be better off checking the data for errors rather than relying on error catching.
|
|
|
|
|
thanks, it is for rare exceptional data. cheers!
I am a SysAdmin, I battle my own daemons.
|
|
|
|
|
im a computer science student, i want to write a program on video conferencing using c# and my C# programming level is very basic. I would like to know if its possible to finish it in a month and i would also like to know what C# topics i should be reading and what other resources i might need for the program.
|
|
|
|
|
Start here[^].
I suspect if you want to write a video conferencing program, you don't know much C#, and you don't know how to do any research, the answer to your question is no, sorry.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Hi i have one doubt regarding creating a object. i refer in google and asked about this from my friends. But i didn't get clear answer from all these sources. I need exact difference between these two. Please can any one can help on this. Dont treat this as a basic question. But it doesn't have exact answers any where.
I have one class name as Employees. Now i want to create an object for this class. what is the difference between the below two?
1. Employees obj;
2. Employees obj = new Employees()
G. Satish
|
|
|
|
|
I answered this question days ago. If you didn't understand the answer, then you should have asked a further question. Either way, the fact that you would ask this at all, and that you can't work out hte answer from your books, or from google, is a fair indication that you are very, very lost, and should not be writing any code that anyone is paying for, or considering buying anything but the most basic of books, if you are serious about reaching a level of being able to write actual, commercial quality code.
This is not an attack, it's the best advice I can give you. Slow down and learn some absolute basics, because you're obviously not at a stage where you know enough to ask questions here and expect to understand the replies.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
hi
first one will not assign memory
Second one will
*** Why EXPERTS behave like a fool ***
|
|
|
|
|
I told him this the other day, he did not reply, and just asked again.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Dot_NET Dude wrote: first one will not assign memory
Second one will
I have a question on this, if you answer ?
When we create like
a) Employee emp;
here we cant use all methods or properties of employee class.
but when we create like
b) Employee emp = new Employee();
then, can use all methods & properties.
I had found this behaviour.
So, my question is if we cant use all methods by creating
Employee emp;
then what is the use of it?
|
|
|
|
|
The core answer here is that you have significant gaps in your most basic, elementary knowledge and need to be reading a basic book, so that you can establish some fundamentals. Please do that.
As I answered satish before, although sadly he never responds, he just fails to understand and yet decides to ask again ( which means he will never learn ), Employee emp does not create an employee at all. It creates the space to hold an employee. It's really a shorthand for Employee emp = null; What use is it ? Well, one obvious thing is that one may do this in code:
private Employee _employee = null;
public Employee CurrentEmployee
{
get
{
if (_employee == null)
{
employee = LoadEmployee();
}
return _employee;
}
}
This is called lazy initialisation. This means the program doesn't pay the cost of creating this employee, until it needs it, but then it only pays the price once.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
