Visual Basic.NET My Application "Poor Performance"

  • Thread starter Thread starter Joel Vazquez
  • Start date Start date
J

Joel Vazquez

Visual Basic.NET Application RunTime Crashes and Stalls

Im a newbie if you could say in .NET ive been working with it the past
3 months and have done lots of things with it, without any prior
knowledge.

I have a few question regarding the stability of my application.
I have a synchronization application that connects to a service and
send the results to SQL Server 2000. I got all my code in just one
form.

This are the functions i have.
GetOrders()
GetPayments()
SyncCustomers()
SyncProducts()
SyncInvoices()
SyncBalances()
SetDate()

So i got a Synchronize Button and i execute them in that exact order.

Private Sub btnSync_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles btnSync.Click
'Initizalize Functions
btnSync.Enabled = False
GetOrders()
GetPayments()
SyncCustomers()
SyncProducts()
SyncInvoices()
SyncBalances()
SetDate()
End Sub

This module handle a lot of data for example i could have 1350 Orders
for a whole month, have 1000 Payments, have 5000 customers and so on.

So as you can see It handles a lot of Data.

Ok the Main Problem when the application executes you cannot use the
PC not even touch a damn mouse cause if you do the Form disappears and
the Application Crashes. Dont get me wrong if I dont use the PC it
works well and it can finish in about 15 to 30 minutes depending on
the data and internet connection.

IS there a way to call this functions better for a nicer performace?

any help is greatly appreciated.

thank you
 
You might want to consider executing your data operations on a seperate
thread, to avoid locking up the GPU during long operations.
 
Hi Joel,

Try to start the synchronization in anther thread. So the main thread can
go on without waiting for the result.

For more information about starting a new thread, please refer to

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/
frlrfsystemthreadingthreadclasstopic.asp

HTH

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

--------------------
| From: Joel Vazquez <[email protected]>
| Subject: Visual Basic.NET My Application "Poor Performance"
| Date: Thu, 25 Sep 2003 13:28:24 -0400
| Message-ID: <[email protected]>
| X-Newsreader: Forte Free Agent 1.93/32.576 English (American)
| MIME-Version: 1.0
| Content-Type: text/plain; charset=us-ascii
| Content-Transfer-Encoding: 7bit
| Newsgroups: microsoft.public.dotnet.languages.vb
| NNTP-Posting-Host: 64.152.137.138
| Lines: 1
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP11.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.languages.vb:141223
| X-Tomcat-NG: microsoft.public.dotnet.languages.vb
|
| Visual Basic.NET Application RunTime Crashes and Stalls
|
| Im a newbie if you could say in .NET ive been working with it the past
| 3 months and have done lots of things with it, without any prior
| knowledge.
|
| I have a few question regarding the stability of my application.
| I have a synchronization application that connects to a service and
| send the results to SQL Server 2000. I got all my code in just one
| form.
|
| This are the functions i have.
| GetOrders()
| GetPayments()
| SyncCustomers()
| SyncProducts()
| SyncInvoices()
| SyncBalances()
| SetDate()
|
| So i got a Synchronize Button and i execute them in that exact order.
|
| Private Sub btnSync_Click(ByVal sender As System.Object, ByVal e As
| System.EventArgs) Handles btnSync.Click
| 'Initizalize Functions
| btnSync.Enabled = False
| GetOrders()
| GetPayments()
| SyncCustomers()
| SyncProducts()
| SyncInvoices()
| SyncBalances()
| SetDate()
| End Sub
|
| This module handle a lot of data for example i could have 1350 Orders
| for a whole month, have 1000 Payments, have 5000 customers and so on.
|
| So as you can see It handles a lot of Data.
|
| Ok the Main Problem when the application executes you cannot use the
| PC not even touch a damn mouse cause if you do the Form disappears and
| the Application Crashes. Dont get me wrong if I dont use the PC it
| works well and it can finish in about 15 to 30 minutes depending on
| the data and internet connection.
|
| IS there a way to call this functions better for a nicer performace?
|
| any help is greatly appreciated.
|
| thank you
|
|
 
Back
Top