MySqlDataAdapter.Fill Takes Almost 6 - 7 Seconds
May 13, 2012
I run a simple SELECT (noted below) in a stored procedure of a table that's around 1,500 rows.
[Code]...
This operation takes around 7 seconds. I inserted Breakpoints and used F11 to determine that upon MySqlAdapter.Fill is where the lag starts. Both my computer and the server hosting the MySQL database are NOT challenged spec wise. I'm guessing it's the query itself. collectionitem holds the 2 foreign keys linking an itemproperty to a collection. we feed the sproc sId(PK of collection) so that the subquery returns all the itemids from a specific collection and then we use the itemid(PK) in itemproperty. Is there any way to speed up the process?
UPDATE My issue was entirely due to improper indexing. Once I learned which columns to index, everything is extremely smooth!
View 2 Replies
ADVERTISEMENT
Jun 14, 2012
Quick question - if I have a timer set to 5000 (5 seconds) and the code in the timer takes longer than 5 seconds to run because of sql stuff, will the timer wait until the code is done till it fires again?
View 3 Replies
Dec 11, 2009
In my new application i have to process a SQL statement.Depending on the settings , the statement takes between 10 an 20 seconds.is there a possibility to display a second from / dialog / popup for this time?
View 5 Replies
Oct 14, 2010
Say you wanted to set a status message
' Set status
ssMainMessages.Text = msgValidating
Then perform an action that requires a http request that takes around 5 seconds then you want to display the result of that
' Set status
ssMainMessages.Text = msgValidated
It will only always display the second message? Its like it jumps the first part of the code and goes straight to httprequest.even if you put the update,system,threading.thread.sleep ....
View 2 Replies
Apr 25, 2010
When starting the default browser like this: Dim trgt1 As String = [URL]
[Code]...
View 10 Replies
Mar 25, 2011
An in-line table valued function in SSMS takes about 6 seconds to return 11088 records. The same function in VB .Net 4.0 using TableAdapters.InputTableAdapter.GetData (Created with data set designer) takes about 15 minutes complete.Both are executed from the same workstation.Why does this discrepancy exist?
Workstation:
Windows XP SP3, 2GB
VS2010 Ultimate
.Net 4.0 Framework
Server:
SQL Server 2008
View 3 Replies
Jun 8, 2011
I need to create an on-screen shape (circle) that has a fill color, which will blink every X seconds (go from fill color, to white, back to fill color). This is trivial to do...BUT... i want to do it in my own class, so that I can instantiate it numerous times passing it unique coordinates for each instantiation.
How do I do it? Can a class have its own "timer control" in it independent from the form? How would I draw a shape from a class?
View 2 Replies
Jun 30, 2011
I want to convert seconds such as 254565443 seconds to hours, minutes, and seconds and thought if I could remove the decimal and the numbers behind it and not change the number in front of the decimal then it would work.
dim seconds = 254565443
dim Hour
dim minute
[Code]....
View 3 Replies
Jun 25, 2010
This is my function to goto a specific time in a movie or music, ... check it out..
'GOTO TIME IN MOVIE, or SONG.
Private Sub Button5_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button5.Click
[Code]....
View 4 Replies
Sep 23, 2009
I just want to display data of a single column from an oracle table into a datagridview or a listbox for readonly with no requirements to make changes to it. Simply display the information.What is the best way forward... To used DATAADAPTER or DATAREADER.s DATAGRIDVIEW SLOWER TO FILL THAN a LISTBOX.i am using the following code to fill datatgridview but for some odd reasons at time it is slow to display the data. I want to use listbox instead
Dim ds As New DataSet
Dim adp As OracleDataAdapter
adp = New OracleDataAdapter("select customer_name from customers")
[code].....
View 7 Replies
May 10, 2010
A couple days, I figured up a working program and it was def. faster than what we needed. Now, adding a couple more loops, the program barely uses any memory, but the cpu used spikes up to 90+ and just letting it sit doesn't help.I tried taking out the couple loops I put in, but it does not revert back to being fast. It's nothing big, but since dealing with 1000+ excel files a day, I'd rather not do that by hand.
how many infinite loops vb.net can support without dragging down the system? I know, infinite loops are poor design, but it works.
View 11 Replies
Feb 9, 2010
When I run my .net application exe .It takes time while loading first time How can I reduce a loading time of my application exe ?
View 6 Replies
Apr 24, 2012
I have a multi-threaded application that sends requests to my online app and that page is less than 1kb now the question is how do 15 threads take 300kbs
View 1 Replies
Feb 2, 2010
im using asp.net with vb.net in backcode. On my first page, i diplay names of all employees. I want to give that a hyperlink, that when clicked upon shall open the next page with say a querystring and opn only that employees records. Also I want the save the employeeid (which is not shown on page 1) on the second page, cause when i do updates on second page, I want to use that employeeId in "where" clause for update or insert statements.
View 2 Replies
Feb 4, 2010
When I run my .net application exe .It takes time while loading How can i reduce a loading time of my application exe.
View 2 Replies
Feb 1, 2012
I designing a form with different control have different opacity values.the problem is when i use the transparency key method to make a portion of the form transparent the resulting form and text is not smooth and traces of the transparency colours can be seen is there a way to remove this or any other way to implement transparency?
View 2 Replies
Apr 16, 2012
I have a client application that connects to a WCF service, i get the file size from the server as a long value then i convert it at the client to a string so it appears like ex:52.21 MB the application gets too many files sizes every time user changes the directory pathso the question is :should i convert the values to a string format from WCF service app then return it to the client as a string format or should i just return the size as a long value and let the client to convert it to a string format in other way which value take more bytes in the memory:
[Code]...
View 3 Replies
Aug 3, 2010
Ok, this might be something stupid that im not doing right, but here is my problem. Im moving from my 1st form, a small window, into my second form, that is full screen, but it takes like 4-5 seconds to load the full form. It sucks because during this 4-5 second load time, parts of the form at transparent and it just look bad. I think it might be because i have around 35 labels and a few other objects on the form. Does anyone know a way to make this not happen? Im in VB08.
View 14 Replies
Jan 1, 2012
I have a function that takes a String as a parameter And in it I have variables, so if I call it it's like
Dim Text As String = MyStringConverter("Hello Mr. " & Name & " " & Surname "!")
View 4 Replies
Jan 28, 2009
I'm using the following code to fetch a mac address
Try
Dim cls As New ManagementClass("\" & IP & "
ootcimv2", "Win32_NetworkAdapter", New ObjectGetOptions(Nothing, TimeSpan.MaxValue, False))
Dim col As Object
[Code]...
It is working as expected. My problem is that it seems to wait far too long for devices which do not respond, and when the output of GotMac is "The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)" How do I shorten the wait time for these types of events?
View 5 Replies
Dec 23, 2010
I have a method/sub that takes an object as a parameter, then it scans through a panels controls and trys to find if it is in the window.
Public Sub removetype (ByVal findobject As Object)
Dim types As System.Type = findobject.GetType
For Each ThisCtrl In Flow.Controls 'flow is a panel
[Code]......
View 3 Replies
Oct 26, 2009
I am writing a program that takes a SSN into a number field.Issue is when a SSN is entered with a leading 0. Ex. 012-34-5678 The zero is cut off and turns it into an 8 byte field, which is not good for SSN obviously.What can I do to prevent this from happening?
View 10 Replies
Mar 18, 2009
I have some code that takes a screen capture of my monitor. This code seems to work perfectly OK and can take multiple screen captures, apart from when I do a Print Screen using the keyboard or open SnagIT 8, when I then try to run my code again I get an error "A generic error occured in GDI+"
I am at a bit of a loss, I have had a look on the internet, but everything I seem to find appears to be related to web apps. and access permissions. This is a window based application and therefore can not seem to find an answer.Below is the code I am running:
[Code]...
View 1 Replies
Dec 4, 2009
Ok, this is going to be a bit bizarre, but I'm looking for something strange, so all suggestions are welcome:I have a function that takes a single byte as an argument. From that byte, without using any random function, I need to create two other random bytes. I specifically cannot use the Random object, but fortunately, the other bytes do not need to be random relative to the argument. Also, the argument is random.
Therefore, one other byte can be created by XORing with &HFF, which will create the inverse of the argument. Since the argument is random, the inverse is also random. I need one other technique that will create that last pseudo-random byte. I thought about bit shifting, but that results in something quite a bit less than random (it will be biased high or low, depending on the bit shifting).
One possibility that I am trying is to use CByte(100000/arg). Does anybody have any other suggestions?
EDIT: The result of that equation for all values of the argument is a very interesting pattern. It will probably be fine, but I'd still take suggestions.
View 10 Replies
Jul 23, 2009
I have the following expression that takes a value in a combo box and appends it to a string :
Dim Expression As String = "COMPANY = '" & cmbCompany.Text & "'"
View 2 Replies
Jul 4, 2011
Was just wondering, why would a 70KB application takes almost 10MB of RAM? All the application does is that it shows the amount fo FREE RAM my computer has. It has 2 pictures, an icon and 2 labels. The amount remains the same, it doesn't increase with the passing of time, I just think such a small application shouldn't eat that much memory.
All code is below:
vb.net
Public Class Form1
Dim drag As Boolean
Dim mousex, mousey As Integer
[Code]....
View 5 Replies
Apr 5, 2011
I achieved all functionality what was needed but my issue is creating and disposing the object is time consuming.Is there any method by which we can make it faster .
I am using word object for spell checking in richtextbox
View 3 Replies
Dec 16, 2011
I am creating a WPF Application that uses Fluent library.
On my computer with Windows 7, 2GB RAM and AMD Triple Core processor, after double clicking on the program icon, The Splash image shows after about 1-2 seconds.
But on my brother's old computer with Windows XP, 512MB RAM and Intel Celeron 2.0 GHz Processor (Single core), after double clicking on the program icon, First, a process called PresentationFontCache.exe runs and it uses almost 100% of CPU for some seconds. And Total time is needed for displaying the initial Splash image is almost 30 seconds (or more).
I don't want that some users have to wait 30 seconds for displaying splash image and about 7-8 seconds for loading application. (my application load process takes 7-8 seconds)
View 3 Replies
Jan 22, 2011
How would i write a program that takes three values X Y and Symbol. the program is supposed to display a rectangle which is X
View 1 Replies
Apr 29, 2010
Is there a way in vb.net to create a sub/function that will take as an argument some kind of pointer to another function, and allow this new sub/function to execute the passed function? What I have are 10-12 xml-rpc functions I am calling against a remote server. Each of these functions has different argument lists (one takes 1 string, another might take 3 strings and one int, etc). All of them return an object.
[Code]...
View 4 Replies
