473,320 Members | 1,724 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Visual Basic.NET My Application "Poor Performance"

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

Nov 20 '05 #1
2 1588
You might want to consider executing your data operations on a seperate
thread, to avoid locking up the GPU during long operations.

"Joel Vazquez" <00*@jamesbond.com> wrote in message
news:cb********************************@4ax.com...
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

Nov 20 '05 #2
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/de...us/cpref/html/
frlrfsystemthreadingthreadclasstopic.asp

HTH

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

--------------------
| From: Joel Vazquez <00*@jamesbond.com>
| Subject: Visual Basic.NET My Application "Poor Performance"
| Date: Thu, 25 Sep 2003 13:28:24 -0400
| Message-ID: <cb********************************@4ax.com>
| 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!TK2MSFTN GP11.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
|
|

Nov 20 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Dominic | last post by:
Hi all, We've just migrated to IIS 6.0 / Windows Server 2003. We are now experiencing some stability problem what we did not experience in IIS 5.0 / Windows 2000 Server. Our ASP.NET application...
1
by: Mark R. Dawson | last post by:
A while ago there was a post where someone asked how to find if a type was derived from another type, three ways were mentioned: Solution1:...
3
by: Benny Ng | last post by:
Dear All, Now I met some performance problems in my application. Because according to our business. The size of some web forms are larger than 1xxx MB. So it takes a long time for user opening a...
1
by: mjheitland | last post by:
Hello, does anyone know if an update is available (or at least planned) for the much cited standard reference IMPROVING .NET APPLICATION PERFORMANCE AND SCALABILITY? link:...
2
by: MohamedSaleh | last post by:
HI all I have the following problem Table SOURCE has columns <char COL1, integar COL2> and has rows {A,1}, {A,2,}, {,A,3}, {B,1}, {B,2},, {C,1},
4
by: Rob | last post by:
I've got quite an already complex form to which I need to add a upload photo facility. I know how to do this but wondered if adding the form tag to include enctype="multipart/form-data" makes a big...
0
by: =?Utf-8?B?cmZsYXphcm8=?= | last post by:
Hi All, We are trying to build an automation utility to configure OS. I found a way to automate the process below via registry: Control Panel -System Properties -Advanced tab -Performance...
3
by: Rahul Babbar | last post by:
Hi, I had the following doubts about the "For Read Only" clause. 1. How does a "for Read only" clause improve the performance? 2. How does a "for Read only" clause compare with "With UR"...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.