Im using VB2010 professional edition and Ms Access 2007 DB. Main form contains a button which accesses database, fetch results in textboxes and update database. But sometimes it takes almost 40seconds to fetch and sometimes it fetches immediately. Couldn't understand any pattern for this. The table in the database contains 8000records and Main form has 3000 lines of code.
View 2 RepliesI have a .NET application (VB.NET) that runs against a MS Access database. Every data request connects to the access database, runs and returns the query and closes the connection back again. I placed the database on a windows xp 32-bit machine. I have two clients on which I installed the .NET application. Both clients are running windows 7 professional 32-bit. Now I have a performance problem with this.
When I use the first client it runs fine. All data is shown very fast. When I than use the second client, it takes some 10 seconds to connect to the database, fetch the data and close the database connection. When i ask for other data on that second client, it all runs fine, until I request data from the first client than back again. Than it takes again 10 seconds on the first client before my data is fetched.
I save Data in MS Access Is too slow. I click Save button [Saved Msgbox appear] then I see the table there is no changes, after 5-6 second it take effects. The code is....
[Code]...
I have to generate about 800 excel files from an access database.
For the first 10-15 of them it's working nice, a few seconds/excel file but it's constantly taking longer, at the 150th excel file it's taking 10 minutes.
Here is my code:
It's doing this for each nrliste in the access table (about 800 of them)
Dim lista = From ls In Liste _
Where ls!Concatenare = nrliste(i) _
Select ls
[Code].....
I have looked all over for a solution to this problem and have tried a bunch of different things, but nothing seems to work.I have a sub procedure that does the following:
1) adds two columns to a data table (table1)
2) fills a dataset with several tables in order to make calculations (this determines the data that will be stored in the two new columns of table1)
3) updates ONLY table1, and ONLY the two columns that have just been added (these columns are thus empty for every row before the update begins)
As it is now, the da.Update takes about 3 hours to populate the entire table (it updates about 300 records per MINUTE if I'm lucky). There are approximately 40000 records in table1 for this test subset, but there will eventually be up to 1.5-2 million (in other words, this is a small table currently). I have tried using executenonquery() along with a sql UPDATE command instead of da.Update, as well as many other things, but none of them has improved performance at all. I've also tested it on two PCs, one running Vista and one XP, and there were no differences. I'm using Access 2003. I know Access is not ideal, but for now it is the only option.
I know that the root of this is the line of code with the da.Update, because the giant loop before it that I previously thought was causing the slowdown executes in 30 seconds, leaving only the update before the subroutine is complete. I don't know how exactly the da.Update works, but I've suspected that maybe it has something to do with that? Code is below:
[code]...
I have built an application using VB 2005 express edition with backend Ms Access 2000. In main form(which is loaded on startup), I am having 9 datagridviews, each bound with databindingsources. I am refreshing this data every 15 seconds by refilling the table adapters and updating the datagridviews.Now, this access database is shared in the network and is accessed by about 5-6 users concurrently. There are other forms which are used to edit the data.My problem is poor performance of the application. Its very slow in opening up forms, not responding sometimes and using the network resources fully.
View 5 RepliesI noticed that my application is running a bit slow. This is a Windows Service built using VB2010 with SQL Server as a back end. Its main function is to poll a folder looking for a text file. If found it reads the text file and imports the data into SQL Server.
While the slowness could be caused by a number of reasons, I am looking at my code to determine if it could be more efficient. Below I've pasted snippets of code where I initialize the DB connection and execute SQL statements. I've also included a snippet that illustrates how I am processing the text file.
I'd appreciate if the group could have a look at these and let me know if the method that I am using is the most efficient possible. At this time I am also focusing on other probable issues, but I can't rule out the possibility that the code that is in place might be a contributing factor.
[Code]...
I'm using Visual Basic Express 2008 to create an interface with a order database in MS Access 2007 (.accdb file). Everything is fully functional except updating the "Inventory" table is very slow. Updating around 2200 items takes almost 2 minutes and the window will appear as "not responding" for the duration if you click away and come back. Here is the process:1. Tab-delimited text file is picked by user, which includes all inventory items (not just new ones)2. Each line from text is parsed and read into variables (tempSKU, tempItemTitle, etc.)3. Old items are updated and new ones are added. -> This is the bottleneck
I used to have a series of IF statements to check which elements were changed and report them, but that was about 2x as slow. The new code is a little faster but doesn't provide the feedback I liked (update part is commented around):
Private Sub btnImportInv_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) andles btnImportInv.Click
Dim strName As String
[code]....
I make a program to check certain website.
The idea is to do webclient.DownloadStringAsync thingy and then wait till each one is solved. So like multi threading application.
The program itself is a single thread.
Well, when I loop 400 times it takes too long. Every time I press pause the program in debug it stop at this line[code]...
Currently, the sendkeys command is too fast for a game called "Minecraft" to process. Here is the code I got currently:
for the button:
appactive("Minecraft")
timer1.enabled
[code].....
Something happened to my VS2005 setup and now the first time load for F1 can take a full minute to load. I think the last significant thing I did was install an add-in for ESRI ArcExplorer. I uninstalled that add-in but help is stil VERY slow to start.Does anyone recognize the problem and have a simple fix?
View 2 RepliesIs there any way that i can be able to get the ExecutenonQuery to Execute faster. Am using it to run mysql queries that have joins from diffrent tables. As I have come to notice, the user has to wait a while before the statement ExecutenonQuery can be completely executed.. is there any way that I can get it to execute faster?
View 2 RepliesWe have old VB6 code, and now that Windows 8 is coming along, we are worried that it won't work. So we have to decide what to port it to. VB.net would seem to make sense, but since it compiles to an intermediate level, its not as fast as programs that compile straight to assembly language. Another choice we found was "Power Basic" which is supposed to be much faster that VB.net.
I happen to like various features of VB.net such as the GUI editor, and intellisense and so forth, and so I'm wondering - is there some way to get around the MSIL (intermediate level) factor in slowing the language down?
its' only me, or is VS2010 really so slooow? This taking 50 seconds to open vs2010, 30 seconds to change from an small project to other small project.as a comparation, in the same machine I can open three different vb6 projects, each one in one different vb6 instance and each one takes "only" three to five seconds. of course I can maintain all the three instances opened all the day, sutching from one to other, debugging, changing, even generatin' exe files, without noticeable penalties.machine is Dell Vostro 1700 4 GB, two internal disks, Win Vista business, Intel Core 2 Duo T 7500 2,2 GHz. two years old.
View 4 RepliesI have a simple code that looks up a text file, reads the line of text, splits the string by semi-colons and then posts the results.
After it has done this, I have created a really simple while loop to waste 10 seconds before going for it again.... here is the code:
Private Sub checkTemps()
While Abort = False
Try
[Code]....
I have this program, which prints a sine wave but it's too fast, how can I slow down the console's line printing speed?
[code...]
am using system.net.mail to send email as shown below, but its too slow. it takes about a minute to send, whats wrong with my code. Am calling the code below in backgroundworker_dowork. is there a faster alternative, maybe free or open source code
' send the email '
Dim smtp As SmtpClient = New SmtpClient()
Dim mail As New MailMessage()[code]............
All of a sudden all vb programs running very slow in XP...... nothing has changed.I took the vb2008 complete out, and reinstalled...... and no difference. other programs like excel run as before, just all my vb2008 programs are really slow.....
View 2 RepliesBasically i have designed an app that runs smoothly on my desktop PC (3GHz processor, 2GB RAM, Windows XP Media Centre (SP3)).
When i put the app on my laptop(1.4GHz processor, 448MB RAM, Windows XP Home Edition (SP2)) it runs really slow and is unusable.
I have tried deploying the app and also just copy the whole folder to my laptop and run the apps *.exe from the bin/debug folder, but it has the same results.
I have tested it on higher spec machines with 2GB RAM and they also replicate the slowness, so i'm at a loss as to why it behaves 100% on my desktop PC, where i have Visual Studio installed but not on any other machine.
My question is if little differences like operating system, RAM, service packs, VS installation, etc, make apps run differently on different machines.
I have designed an application just like it is an Excel table. By changing each textbox the application runs a huge amount of vb code and it takes time.
E.g. you want to enter a three digits number it takes from two to four and sometimes more seconds for ech digit to enter. That`s really embarrassing.
I have a problem with a application, when i start the program the speed is ok.after 1 hour of use the prohram go very slow.
View 7 RepliesI didn't think that setting a background of a form may slow it down seriously, but it's real now
View 3 RepliesI've got a vb.net 2005 form that calls a stored proc to load a combobox with eligible sales reps. There are approximately 40k sales reps available...I know that's a lot, but that's what I'm dealing with. I'm trying to figure out why it's taking this form 15 seconds to load.
Here's my code:
Want to load this in the most efficient way possible given the HUGE amount of data that my client is wanting to see.
Can you help me? :confused:
i know this question was asked a couple of years ago by TheMinistered .. but i cannot find an answer, and i have exaclty the same problem (using both VB6 and VB.net 2003) :
When I attempt to connect to a remote SQL server via ADO it takes almost 20-30 seconds before Open returns. I don't know if it's something I'm doing wrong... here is my connection string/code:
Private Sub Class_Initialize()
Dim strConnectionString As String
Set m_objConnection = New Connection
[Code]......
I'm writing a application that need to execute a certain code several times a second. At first, i wrote a Function and used it. But it was too slow... So, using Stopwatch i started measuring the performance of my code. And apparently it was from the funcion call. So i wrote a example code, just a simple loop. And using the Stopwatch it took 4E-6 = 0.000004 seconds. Then i copy and paste the loop code, into a function and made a call to the function. it took 0.03 seconds. It was 7500 times slower with a function call. Why using a function call can be so much slower?[code]...
View 9 RepliesI have the following code to manipulate the points in a path before drawing it.
Private Function CurvePath(ByVal inputPath As GraphicsPath) As GraphicsPath
Dim tmpPath As New GraphicsPath
Dim newPath As New GraphicsPath
[code].....
I'm upgrading my VB6 program to VB 2008 express .but the IDE is too slow. When I change something it takes 1-2 minutes before I can do anything else?
View 1 RepliesI'm using Visual Studio 2010 Pro on a Windows 7 PC, to build simple VB Windows Form Applications (I've just started learning VB). Lately when I try to debug my applications, it takes unusually long. For example, an application with just a blank form and nothing else will take about a minute to build, and then it will sit for another minute or two until the app window pops up. It didn't use to do this!
View 1 RepliesMy stats:OS: XP Professional (2002) SP2Pentium 4 CPU, 3.2 Ghz, 2.98 G RAMApp: VS 2008 Pro. v 9.0.21022.8 RTM
View 3 Repliesusing System;
using System.Collections.Generic;
using System.ComponentModel;
[code].....