PFB the code for a search button where when a user enters a text in the text box ,it takes the keyword compares it with an xls which has 1600 rows and 16 columns with keywords.If the keywords match, it has to full the 3rd column where the name is specified.Its running but its taking more than 20-25 mins for processing.I knw searching 1600 rows and 16 columns will take time but pls advice if i can make this process a lil faster.
[Code]...
My application does some intensive tasks on a second thread, while updating the main form. I want to show how long these tasks have been running (increments every second), i've read timers can get out of sync and even fire off multiple ticks at once, so how can that be fixed, or what's a better solution for this?
View 3 RepliesActually, I am trying to find out whether the partno is existing in the database table or not and it takes long time in count = checkCommand.ExecuteReader statement
Public Function CheckProductNo(ByVal Partno As String) As Boolean
Dim count As SqlDataReader
Dim valid As Boolean = False
Using connection As New SqlConnection
[code]....
Recently, I've been running some tests with C++ and VB.NET to compare execution speeds. In the last thread I posted, I talked about how I had encountered the fact that C++ was executing just as fast as VB, but got that issue resolved. Now I'm hitting my head against another wall:I had made a DLL for VB.NET to test out this theory and compare in just one program side by side execution time of identical VB.NET and C++ code. But the interesting thing? VB.NET's execution time improved such that it was now exactly identical to the execution time of C++. Spending some time with the problem, I discovered that the "Target CPU" option in advanced compile options in Visual Studio 2008 was the culprit!
Since I'm running 64-bit Windows 7, I figured making the target CPU x64 would yield the best execution time. Wrong. Here are the results in execution time of a Windows Forms application for VB.NET,calculating all the prime numbers up to 10,000,000 and getting their sum.
Any CPU: 15.231 seconds
x86: 10.858 seconds
x64: 15.236 seconds
Below is the code I'm using, feel free to test it yourself:Public Class Form1
[Code]....
I was updating an old .aspx.vb script that was originally written with dynamically typed variables, like this:
Dim price I updated them to the following format (along with some IsDBNull checks to compensate):
Dim price As String After doing this to all of my variables, the script appeared to run noticeably faster. Is this a real effect of static typing, or is it just a coincidence?
Windows Application
Front End: Vb.net
Backend: Oracle 10g
I am executing the sql query to fetch values and showing it in my datagrid..and when i do that it works perfectly fine...and problem is that it takes 10 min for my datagrid to fill...so in between i want to show the execution time to the user in another form till my query processing completes..
My
Dim oradb As String = "Data Source=zorb;User Id=baady;Password=zacky;"
Dim conn As New OracleConnection(oradb) ' VB.NET
Try[code]......
I have a per-call WCF service that serves a number of clients. I'm looking to speed up the services by running some background processes so they don't block or slow down the main function of the services.
One example is that the main function needs to return a set of data, while the background thread needs to record some statistics based on the parameter(s).
Code:
Public Function GetAccountDetails(id As Integer) As AccountDetails
Dim retVal As New AccountDetails
Dim a As New Accounts
[Code]....
If I use this background thread to record the statistic it doesn't block the main thread from returning the data to the client.
It's been working well in test scenarios, but my question is, are there any dangers with leaving this thread to execute without Joining it before returning the data to the client? Could there potentially be any loss of statistic data? Could there be potential memory problems on the server side?
FIRST = arguments checked against each other
SECOND = arguments checked against each other but are irregardless of the FIRST arguments.
If (FIRST and (FIRST or (FIRST and FIRST))) OR (SECOND or (SECOND or SECOND or (SECOND and (SECOND or SECOND)))) then As the program processes this line over a million times during the execution, only FIRST or SECOND section is needed during an execution, never both. How do I make the program use only the section that's needed for the current execution instead of checking every argument every time? Is there a way to turn a string into an argument list for an IF...THEN statement? [code]
Is it possible to wait/suspend execution for a certain amout of time without hanging the main UI thread?
View 7 RepliesI'm working on a project that calls for high-performance networking with TLS encryption in VB.NET. The stock SSLStream sucks rotten eggs; its 'asynchronous' read/write operations aren't async at all, meaning that they'll operate parallel to each other and to the main thread but that it offers absolutely nothing that resembles async read/read and write/write, which means that reads are totally synchronous to each other and writes are too (only 1 read and only 1 write can be done at a time).
I've done a lot of reading on this failing and it seems like MS has no intention of ever fixing this.Hoping a whole lot not to have to write my own TLS implementation. I've tried the Mentalis open source SSL suite, which will NOT compile. I've tried SocketWrench tools which will not compile under VS 2010 (and whose documentation indicates it's in fact synchronous on its async threads too; can only do 1 async read and 1 async write at a time).
What I want/need is an SSL/TLS implementation that actually works with DotNET that actually allows me to do multiple asynch reads/writes over a TCP/IP transport stream. Anybody have any experience or recommendations on 3rd party toolkits or alternate methods of SSLStream I/O?
I need to calculate the high score and am having trouble storing a value that represents the previous high score, and the comparator funcion.
Public n_sErrorTitle As String = "Entry Error"
'Count the number of entered scores
Dim intCount As Integer
[code]....
how can i save a high score in toolstrip textbox or listbox?
View 7 RepliesWhere can I find some books that might be used at the High School level to teach students programming using Visual Basic from the ground up, assuming no knowledge of programming?
View 5 Replieswhats the difference with high and low level of programming
View 1 RepliesI made a game and i made a hp bar.So i made a Heal button but when the value is more then the Maximum value it crash.Any way to fix that? Like something to bypass that go go back to the Maximum Value?
View 7 RepliesI have been asked to improve the memory efficiency of an application that is used for high speed data acquisition. After running the VS memory profiler several times and scanning the projects for obvious issues I came to the following conclusion: despite using a fixed size circular buffer for storing acquired sample points, the RAM usage increases relative to the polling period. For example: polling data for one signal at 2 microseconds can use 5 times more memory (private bytes) than when running at 50 microseconds ... even though the buffer size is the same.
The circular buffer is an array of SamplePoint objects. Each of these objects contains an array of Shorts (16 bit) for corresponding data per signal and one date object (8 bytes) for the time stamp. For efficiency, the circular buffer is Redimmed only once every time it begins polling and filled with empty sample points which are then "assigned".
Also, it seems that when we stop and run the application it hogs even more memory each time as though the Redim is not releasing the previous array. My questions boil down to the following: What is most memory efficient way of implementing a circular buffer containing managed objects which have arrays?Also, how and why is memory usage increasing with a fixed size array with different polling speeds? Does the garbage collector not have time? Do local variables get disposed of IMMEDIATELY when a sub or function exits?These are some of the doubts and concerns that I would like to rule out before proceeding.
[Code]...
I am trying to create a high scores board - currently i was experimenting with just typing a number into a textbox and having it automatically order the numbers (in labels) from largest to smallest however i cannot get them all to work. either just the first and second (label) works or the second and third display the same number or the second decreases in value even though it shouldn't[code]...
View 7 RepliesI have two functions to find the high and low numbers from 5 different textboxes. I want the high in one label (which I have) an the low in another. I cannot seem to get the low number to be anything other than 0. Here is the code:
[Code]...
I'm having some doubts on which communication protocol/platform would be better for my current development. The focus is on communication performance, and while reliability matters, I can handle a some packet loss. UDP sounds like the correct choice, but then the following question came up:
"What would be better, using a UDP socket directly in .NET, or using a UDP socket implemented in unmanaged C++ with a wrapper to .NET?"I'm quite sure that C++ is faster than .NET, and while the communication might be faster, I'm not sure if that performance improvement is not lost with all the C++-to-.NET wrapping?
Some info about the project I'll be using this on:
- The core of the project will be all made in VB.NET.
- There'll be a high packet sending/receiving volume (about 100-200/sec).
- There'll be many clients requesting data to the server.
- Network communication will be over a GB-LAN.
- Data is time sensitive, and some packet loss is accepted.
- Running on .NET 3.5.
I want to make a wallpaper changer because windows high compresses the the image so you see artifacts even if already use a jpeg or even a really high quality png or bmp.
I know what I need to do for all of it I just need to know how to save an image to a jpeg without it being compressed. I have tried using the encoderparamters and getcodecinfo aswell as setting the quality to 100 but I still get a really bad looking image in the end.
Is there a way where I can save an image to a jpeg without getting the crappy image quality like with visual basic?
I have a graphics program and in it I use DrawEllipse plenty and when the pen thickness gets high like around 12 pixels or above you start to see these spikes. I'm using a PictureBox so double buffering is being used. Is there anything I can do to get rid of the "spikes". In the screenshot at top the pen thickness is at 19 and is 28 in the lower.
View 10 RepliesI'm working on a video game in VB .NET and I was wondering if there is any way to store its high scores online.If there is any way to do this, that would be great, but otherwise, I'd like to know what would be the best method of locally storing high scores on a single computer.
View 1 RepliesI have several services that use UDP messages to send out XML status information which is displayed in an application with a UDP listener. This works well. Some of our services are installed at a different site. The UDP messaging does not cross over the routers. Therefore, I wrote a TCP-UDP forwarder service that listens for the UDP messages at the remote site, then forwards them via TCP to a partner service in our local office. That partner service then re-sends the messages via UDP so we may monitor them.
My problem is that the method that sends the messages via TCP appears to be dropping a lot of the XML messages. When the service gets a UDP message, it enqueues it in a queue object for processing. The enqueue statement is enclosed in a synclock object. A separate thread dequeues the message using the same synclock object and sends it via TCP. Originally, I had the code written so that the TCP Send method instantiates the TCPClient, opens it, does a GetSteam, sends the message with a BinaryWriter, closes the writer, closes the stream, closes the client.
Next, I updated the code to declare the TCPClient at the module level. The send method checked to see if the TCPClient variable was nothing and, if it was nothing, instantiated it and connected it. If it was already instantiated, I just tried to re-use it. I close the TCPClient when the service runs the OnStop method. This way did not work. I get "The operation is not allowed on non-connected sockets." errors.
What is the best strategy for implementing a TCP sender that works in a high volume environment. I only have four services sending UDP messages that need to be forwarded at this time. I eventually will have many more.
I am trying to make file transfer program in vb.net 2008 for big files eg. 10 GB.i was able to code simple socket program to transfer files with small size by using Sockets but if the file is large then "File.ReadAllBytes(ComboBox1.Text)" command will not work cause it use lot of memory & if the file is really big i.e. 10 GB it give not enough memory error, so i made a loop that sends data in small amounts, but this give me a larger file size with repeated data at end of the file.
[code]...
I am working on a windows service and I am looking for a better solution to an issue with high CPU usage. The service needs to only 'run' every minute or two to gather some db data and do some light processing. Right now I have it running in a separate thread in the service application using the BackgroundWorker. In that thread, I do a Thread.Sleep(30000) after each db iteration. This has taken care of the CPU issue (obvious) but I am let thinking there is a better way. This works fine, I can still cancel the service without issue etc. however it feels wrong. Blocking that thread seems bad.
That being said, what is the best way to actually do this? I don't want the loop to just constantly run, I only want it to do work on a somewhat regular time frame. Would running this in a timer_elapsed event handler be a better way?
I need to create high quality icons for my current project in vb.net
This is my code so far,
Private Sub CreateIcon(ByVal bitmapName As String)
Try
Dim fi As New System.IO.FileInfo(bitmapName)
[Code].....
But the problem is it only gives me a very low quality icon at the end. how to make a higher quality image?
I am Writing a Program in Visual Basic 2008 for my High Schools Advanced Higher Coursework Project... The Game its self runs perfectly and i can display the highscores. i just need some help showing 10 hi-scorers and in ascending order.Currently i am using this code for viewing them.
Code:
Private Sub HiScores_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim TmpHiScore As String 'Temporarly stores the data in file "HiScores.lol".
Dim intTempo As Integer = 1 'Stores the length of variable TmpHiScore.
[code]....
The hiscores them selfs are stored in a personalised text document and they are all on the one line. the format of this is NAME:SCORE,NAME:SCORE,NAME:SCORE and so on!
I have a small problem with process priorities (Win Server 2003 Standard, 8 Core, 16GB RAM). My VB.NET 2005 program starts a process like this:
Dim WithEvents proc As New Process
Sub Main()
proc.StartInfo.FileName = "blastx.exe"[code].....
In this case, blastx.exe runs on 4 cores.I would expect that my started process is idle and has 0% CPU usage while the system is under full load (I simulate this with prime95, 8 worker threads) and only runs if there are free resources. But it generates 25% cpu load and prime95 only 75% instead of expected 0%/100%. In the task manager, I can see that my process has the lowest priority and prime95 has the normal priority.
I have used flash(.swf) animation & high quality graphical image there in my vb.net application. But problem is that sometimes when I click on menu it shows small line under it & take time to load it. It shows line under menu when load another forms though there is no line under that menu. I have 25 forms & every form has high quality image(image size is 1280*1024). Is there any way to get rid of this problem? Is there any way to make my application smooth though its high graphical & animated?
View 1 RepliesFor logging purposes, some methods in our application include the following line:Dim Log As ILog = GetLog(Reflection.MethodBase.GetCurrentMethod().DeclaringType)I have what might be described as an irrational fear of reflection, which I try to keep in check. However, calls like this in methods that are executed potentially a hundred times a second concern me. I don't know as much as I should about reflection; but from looking briefly over the documentation, it looks to me like I could replace the following with:Dim Log As ILog = GetLog(Me.GetType())My question is three-fold:Does Me.GetType() actually return the same Type as GetCurrentMethod().DeclaringType? Does Me.GetType() actually do anything differently from GetCurrentMethod().DeclaringType, or is it doing the same thing under the hood?
View 3 Replies