Why Is Code 7 Times Slower Than VBA
Feb 29, 2012
I have spent years writing VBA code that has got increasingly complicated. For the first time, I came across the error in VBA "Out Of String Space" when dealing with a 200MB CSV file.To overcome this I copied and pasted all the code over to VB.NET, compiled changed a few errors and ran the new code. The VB.Net takes 15mins, when VBA took 3 mins.For instance,Previously, to read the contents of the CSV file in VBA I used the code,Dim whole_str As String
Open file_path for Input As #1
whole_str = Input$(LOF(1),1)
Close #1
[code].....
View 1 Replies
ADVERTISEMENT
May 5, 2011
VB2010: All, I am using a picturebox to show the constellation of GPS satellites, that starts out OK. I have to redraw every now and then, because if a dialog box gets drawn on top of it, the data doesn't refresh after the dialog box is closed. Same with moving the Frame around the screen, I have to redraw the picturebox. (not sure why, but I can live with that) When I first start the program and received data from the receivers and plot the Constellation the refresh/redraw is very quick, (just a flicker) then after about 30 mins or so the refresh seems to redraw the picturebox slower and slower. I can see the individual satellites (fillellipse) redraw.
Also, I have moved the picturebox into a TAB-frame. Even when I switch from on Tab to another, the picturebox will not refresh automatically. I have to do a clear and then replot the information.
View 10 Replies
Sep 1, 2009
I have a client who needs Excel VBA code that produces formula values moved to VB.NET. He is in the business of providing financial analytics, in this case delivered as an Excel add-in. I have translated the VBA into VB.NET code that runs in a separate DLL. The DLL is compiled as a COM Server because, well, Excel-callable .NET UDFs have to be. So far, so good: Excel cells have "=foo(Range1, Range2, ...)", the VB.NET Com Server's UDF is called, and the cell obtains a value that matches the VBA code's value.
View 7 Replies
Aug 21, 2009
I would like to know how i can easly run a code under a button for x times?
View 6 Replies
Nov 13, 2010
How can I tell something to use a code without completely adding it in that sub again? I have some code that will be used alot within my program. I could write a DLL, but I don't know how to use those!
Here is my code:
Dim str1 As String = System.IO.File.ReadAllText(Me.OpenFileDialog1.FileName)
Dim s2 As String = str1.Replace(".[1gs5]", "a")
s2 = s2.Replace(".[u775]", "b")
s2 = s2.Replace(".[fsef]", "c")
[Code]...
View 4 Replies
Dec 23, 2011
My code gets a list of words from a txt file and chooses the words randomly. However, the same word can appear more than once and i need to know how to stop this from happeningHere is the code:
Dim aryName As String() = Nothing
aryName = File.ReadAllLines(Application.StartupPath & "Randomfnames.txt")
Dim randomWords As New List(Of String)
[code].....
View 3 Replies
Apr 5, 2012
I am working on an OpenGL Visual Basic 2010 Express project using Tao.dlls.My computer has crashed a few times while I was last working on my code.Since then There has been some side effects such as intelisense and autocomplete not working when I load the project, even after checking the options and settings for them.When I start a new project on the other hand the features work again.Also when this OpenGL code is run:
Code:
glutMotionFunc(AddressOf MouseMotionGUI)
I get:
BadImageFormatException unhandeld
An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B)
This code was working fine before my computer crashed and probably corrupted some files.
View 6 Replies
Jan 10, 2011
I have a block of code which is used to save some information to a text file. I need to use this a few different times in my app.I could just copy and paste it each time but that seems messy and is adding unnecessary code. I'm sure I can just save the code once and reference it when I need to. I think it's done in either a module or a class or something
View 8 Replies
Apr 3, 2011
Okay, so basically I'm trying to have my application randomly select items from a (multiselect) listbox. I want the user to enter the amount of items they would like randomly selected and it should all happen at the same time. I have the random shuffle down but it only selects one song each time you click the button. How can I loop this code as many times as the user specifies in the textbox?
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
Dim shuffle As New Random
Main.songlist.SelectedIndex = shuffle.Next(0, Main.songlist.Items.Count - 1)
[code].....
View 1 Replies
Mar 31, 2012
My c++ app (which has both managed and unmanaged dlls) loads very slow ( > 70 sec) during first time startup. After that it takes 20 sec only during startup. Why? How to make it faster always?
I tried with /Delayloading, rebase etc. It did not give much improvement. In fact after rebase it took more time. note that my app has more than 150 dlls
View 3 Replies
Dec 30, 2010
Are anonymous types slower than declarative types?
For example, does
Dim score as Double = CalculateScore()
run slower than
Dim score = CalculateScore()
Why use explicit typing if it's no slower?
View 5 Replies
Apr 13, 2011
how to create a code that clicks on a certain product on a web site thousands of times?
View 2 Replies
Dec 31, 2011
A while ago I wrote a quick and very very simple program to test myself on about 10 questions I needed to remember the answer to. I made a form with a label, text box and button. the label contained the question and the answer was entered into the textbox and the button was pressed to check the answer. the code i used was very similar to this:[code] Because I only had 10 questions it was fine to copy and paste the code a few times and rename the questions but now i am going to use this again but for a lot more questions (in the end there will be a couple of hundred) so i was wondering if any one knew a better way to do this? I was thinking maybe an array like 1 to hold the questions and 1 to hold the answers but i haven't worked much with arrays so I'm not sure how difficult this would be ?
View 1 Replies
Jun 8, 2011
I know that title is kinda miss leading, but i couldnt figure out another way to explain it. I know theres a way, but I dont know how to do it.Ive got a Save code that I have about 5 differnet times in my application. How do I make it so that I can just type in something like Do Save, and it locates the save code and follows it through, then returns to where it was.
View 3 Replies
Feb 17, 2011
Looping code is adding my values multiple times
View 4 Replies
Jun 6, 2012
I have written a program and have used it (in debug mode) multiple times to test it out sometimes adding code and/or changing it. After a while any code I wrote or new buttons or features I added to the form would not appear while debugging. I don't know what circumstances led to this.
The only solution I found was to rewrite my code from scratch, however, the problem came back after a while. I don't know what is going on and I can't move on without starting all over again.
View 1 Replies
Dec 15, 2011
I have a standard scoring algorithm but I need to help on a piece of code to only execute the scoring algorithm at certain times.I want it to be triggered by dates, but the problem arises if the program is used after 2 (or more) dates have passed, the first date will not be added as the second date is the newest and therefore the one that triggers the scoring algorithm. - The scoring algorithm gets the scores for that week, which are stored in a text file.
View 5 Replies
Aug 3, 2009
I converted some code from vb6 to vb2005 that opens a recordset and populates a listbox
with about 8,000 names. It uses classic ado. The vb6 code does it in about 0.75 of a second, the first vb2005 code does it in about 5.5 seconds while the second vb2005 code does it in about 4.5 seconds. Is there any way to improve the vb2005 performance a fair bit more?
[Code]...
View 2 Replies
May 17, 2010
I'm upgrading to VB2008 from VB6 and have noticed that when drawing a small diagram on the screen it is much slower. In VB6 is is drawn 'instantly' in VB2008, 34 lines, 5 arcs and 15 text items are taking 112000,000 ticks to draw- I can see it being drawn line by line. The codes contains the code to draw the diagram and some minor calculations to determine what to draw. If I just draw 4 lines directly it takes 80,000 ticks which looks 'instant'. It looks as if the calculations are slowing it down. Is there some reason for this, is there a box I have not ticked that makes it slow?
View 7 Replies
Dec 12, 2011
I want to enlarge an image, possibly up to 32 times or 64 times bigger than original dimensions (so that the user can see each pixel) if possible. The following is a simple function that I have to enlarge an image.
Private Function xEnlarge(ByVal Source As Image, ByVal Rate As Double, Optional ByVal Quality As Drawing2D.InterpolationMode = Drawing2D.InterpolationMode.HighQualityBicubic) As Image
[Code].....
View 6 Replies
May 13, 2009
I have just started using vb.net and I have a checked list box with times throughout the day shown as
00:00 - 00:14
00:15 - 00:29
00:30 - 00:44
00:45 - 00:59
What I am trying to find is a way to get the current time and find which list item it fits into. What I think I need to do is to first of all get the current time and then go through the list splitting each item into 2 times and seeing if the current time fits. For example: Split the item 00:00 - 00:14 to 00:00 and 00:14 and then check if the current time is more than 00:00:00 but less than 00:14:59 and if so do certain task.how to go about taking each list item and splitting it into 2 separate times so I can check between them?
View 2 Replies
Sep 14, 2010
I have a function where I am performing a lot number of database operations inside a Sub. The operation when called directly like:ExecProcess()
takes about 11 seconds to run.However, if I create a Delegate, and call the sub using BeginInvoke(), the very same process takes over 40 seconds to execute.Here's the threaded code:
Protected del As ProcessDelegate
Protected Delegate Sub ProcessDelegate()
del = New ProcessDelegate(AddressOf SELocal.ExecJob)
Dim cb As New AsyncCallback(AddressOf Me.ExecJobComplete)
del.BeginInvoke(cb, del)
Anyone know what may cause a function to take longer inside a new thread, rather than calling directly?
View 2 Replies
May 12, 2010
Is VB Express 2010 slower to compile and run that older versions of VB Express? I've installed it this weekend and it seems a little sluggish on my quad core computer with 1 gig of RAM. I have VB Express 2005 installed for my students at school and it seems to fly just fine. Those school computers are older P4s with 512k of RAM.
View 7 Replies
Nov 21, 2010
i am trying to make a coin toss program where you toss a coin a certain number of times then repeat it a certain number of times.
the problem i have is "heads(counter2)" the word "heads" has a blue error line under it how do i sort the error out and also is all the code right
Public Class Form1
Dim tosses, repeat, heads As Integer
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[code]....
View 1 Replies
Feb 12, 2011
Consider the following code:
Dim arr1 As New List(Of Double)
Dim arr2 As New List(Of Object)
Dim timeStart As DateTime = Now
For x As Integer = 0 To 1000000
[code]....
It involves 2 lists. The first one is 1-dimensional, the second one is 2-dimensional.The first routine (which operates on the first list) completes in about .015 seconds. The second routine (which operates on the second list), however, takes almost 10 seconds. The only difference is that the second list is 2-dimensional.Is there a way to speed this up or am I doing something wrong? I have a program that requires several 2-dimensional arrays and it's running extremely slow right now. How can I speed it up so I get the same feedback that I'd get if the lists were 1-dimensional?
View 1 Replies
Mar 8, 2010
im currently working with a payroll system as a project i wonder how can i use
TimeDiff(,,,)
in crystal report(FOrmula Fields)what are the proper things to put on it?to find the difference of 2 time or any other way of finding the difference of times?
View 1 Replies
Jan 28, 2010
i want to calculate sum of two times example:
[Code]...
View 7 Replies
Apr 25, 2012
i want to subtract 18 years from a vb date object here's the code example:
Dim someVar
DirectCast(pcontrol, DateTimePicker).Value = Date.Now.Subtract(someVar)
someVar value is ?
View 1 Replies
Mar 31, 2011
I need to tab over a certain amount of times in a text fileI am using chr(9) for the tab, but I don't want to have to put in a bunch of those.
View 3 Replies
Feb 6, 2010
How would you make the Interval of a timer to be between two times.
E.g if you wanted an event to occur between every 7 and 20 seconds?
View 9 Replies
