473,805 Members | 2,154 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

ADO.net -- slowness when writing data

Art
Hi,

I'm working on an application that writes records to an Access database.
What I've got so far works, but very slowly.

I have one class that creates the data -- some of it is as follows (this is
in a block that's reading data).

mFieldValues = String.Format(" Values({0},""{1 }"",""{2}"",""{ 3}"",""{4}"") ", _
.GetInt32(0), .GetString(1), .GetString(3), .GetString(4),
mMyRegion)
mAppender.Appen dLine(mFieldVal ues)

mAppender is a class that does the writing and where the slowness appears to
be. The writing is done here:

Public Sub AppendLine(ByVa l mFieldvalues As String)
dbCmd.CommandTe xt = "INSERT INTO " & mTable & _
Me.FieldNames & mFieldvalues
dbCmd.ExecuteNo nQuery()
End Sub

Does anyone have any suggestions as to what I may be doing wrong. It seems
to take about 1 minute per 500 records. I eliminated the write, and just did
the reading, that went very fast. I hard coded sample values to avoid the
..getstring stuff, that made no difference.

thanks,
Art
Nov 21 '05 #1
0 831

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
3010
by: Jason K | last post by:
Let me preface this by saying this obviously isn't a C++ *language* issue per se; rather probably an issue relating to quality of implementation, unless I'm just misusing iostream... I wrote a function to count lines in a large file that start with a particular pattern. The file can contain large amounts of non-text crap, which may make some lines very long (so using getline() with a std::string isn't feasable). So I dug around looking...
0
1137
by: Nicole | last post by:
Has anyone else experienced a dramatic slow down of performance with their ADP's after upgrading to Service Pack 2 or above? The slowness occurs exclusively when pulling data from SQL Server in the ADp. In Query Analyzer, I can't duplicate the lags, and on machines running SP1 performance continues to be good. I'd like to keep the service packs in place, but performance is unacceptable. Any suggestions appreciated. Thanks,
7
2167
by: Mike Nygard | last post by:
I'm experiencing extremely slow response times in design mode of my forms since moving to Access 2003. Simply dragging a button to a different position on the form takes 30 seconds or more. The record source for my form is an ODBC passthrough query to an Oracle database. I have two XP system identically configured except that one has Access 2000 and the other with Access 2003. I only have this problem with Access 2003. The Access 2003...
2
1184
by: BerkshireGuy | last post by:
I am using Windows 2000 and Access 2003 and noticed that when I click a control on a report, it takes a few seconds for the "click" to take place. Its laggy. Same with moving controls, adding new ones, etc. Any ideas? Users in my company are reporting slowness in MS Word as well. We also have Lotus Notes.
1
2011
by: Dave | last post by:
Hi all, I have a slight problem when using chartfx in vb.net. I have a line graph that needs to be able to plot 10,000 points. I believe that this isn't too unfeasible however whenever I begin plotting the points it slows down immensely. If i Alt-Tab to another full screen application and then Alt-Tab back a few seconds later, the graph has redrawn a lot more of it that it would have had it been on the screen all the time. This...
102
3455
by: sam_cit | last post by:
Hi everyone, I have been asked this question quite a few times and i wonder what could the actual reason? " When to prefer C over C++ or vice versa, of course this is for real world pratical scenario" As per my understanding, C++ makes it easier to program application related logic as OOPS helps in that sense, but for some reason that is
9
1171
by: allenjo5 | last post by:
Here's a code snippet: i = 0 while (i < 20): i = i + 1 (shellIn, shellOut) = os.popen4("/bin/sh -c ':'") # for testing, the spawned shell does nothing print 'next' # for line in shellOut: # print line
1
1199
by: BerkshireGuy | last post by:
I have taken over an access report that is rather involved. Whenever I click on a control to modify the report - there is a long delay. It took 30 minutes just to save the report! Obviously the report and data behind it needs optizimation. Is this common? Any work around solutions? Why would it matter when I am design mode?
0
998
by: =?Utf-8?B?SmFjY2k=?= | last post by:
Hello, I'm having trouble creating a new folder. Right clicking or going to File, New, the arrow turns into an hourglass and for at least a minute, then I can create a new folder. This has been happening for a while now but I don't remember it always being this way. I tried to find the broken shell using shellExView but the only thing that shows a problem is the google toolbar in IE. I disabled that rebooted my PC and still get the same...
0
9596
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10613
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10363
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10368
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10107
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9186
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7649
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5678
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4327
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.