Click here to Skip to main content
15,923,689 members
Home / Discussions / Windows Forms
   

Windows Forms

 
GeneralRe: reply plz Pin
Paul Conrad7-Mar-08 14:50
professionalPaul Conrad7-Mar-08 14:50 
GeneralForm with BackGroundWorkers Pin
Herman<T>.Instance25-Feb-08 2:59
Herman<T>.Instance25-Feb-08 2:59 
GeneralRe: Form with BackGroundWorkers Pin
Luc Pattyn25-Feb-08 5:09
sitebuilderLuc Pattyn25-Feb-08 5:09 
GeneralRe: Form with BackGroundWorkers Pin
Herman<T>.Instance26-Feb-08 2:14
Herman<T>.Instance26-Feb-08 2:14 
GeneralRe: Form with BackGroundWorkers Pin
Luc Pattyn26-Feb-08 2:31
sitebuilderLuc Pattyn26-Feb-08 2:31 
GeneralRe: Form with BackGroundWorkers Pin
Herman<T>.Instance26-Feb-08 4:18
Herman<T>.Instance26-Feb-08 4:18 
GeneralRe: Form with BackGroundWorkers Pin
Luc Pattyn26-Feb-08 4:49
sitebuilderLuc Pattyn26-Feb-08 4:49 
GeneralRe: Form with BackGroundWorkers [modified] Pin
Herman<T>.Instance26-Feb-08 5:00
Herman<T>.Instance26-Feb-08 5:00 
Both BGW connect to 2 different Database on different machines.
Process 1 is a fast one but the second is a time consuming one.
It has to check in 11 tables in 1 query. If that gives two rows of result the next agreement has to be found.
I use about 100 queries for determining the proces for 1 DBC in an arraylist.

What I do each time is to add an object in an arraylist. Based on the data in the datareader containing 25 or 1000 lines for proces 2 and 10000 lines for proces 1.

I did create an OnActiveChanged event for the Form and if I add Application.DoEvents(); The freeze get a bit less.
That's all!


Small Test results
I did check the DatabaseServer that will receive the information via Insert INTO sql's.
When I start my program the Database is at 0%. As soon as I hit the Start button the CPU for SqlServer raises up to 40-50%. It stays stable until I press the Cancel button.
My program freezes and the SqlServer user 70-80%........
This is NOT funny Frown | :(

modified on Tuesday, February 26, 2008 11:08 AM

GeneralRe: Form with BackGroundWorkers Pin
Luc Pattyn26-Feb-08 5:14
sitebuilderLuc Pattyn26-Feb-08 5:14 
GeneralRe: Form with BackGroundWorkers Pin
Herman<T>.Instance26-Feb-08 6:03
Herman<T>.Instance26-Feb-08 6:03 
GeneralRe: Form with BackGroundWorkers Pin
Luc Pattyn26-Feb-08 6:09
sitebuilderLuc Pattyn26-Feb-08 6:09 
GeneralRe: Form with BackGroundWorkers Pin
Herman<T>.Instance26-Feb-08 23:01
Herman<T>.Instance26-Feb-08 23:01 
GeneralRe: Form with BackGroundWorkers Pin
Luc Pattyn26-Feb-08 23:50
sitebuilderLuc Pattyn26-Feb-08 23:50 
GeneralRe: Form with BackGroundWorkers [modified] Pin
Herman<T>.Instance27-Feb-08 1:15
Herman<T>.Instance27-Feb-08 1:15 
GeneralRe: Form with BackGroundWorkers Pin
Luc Pattyn27-Feb-08 4:04
sitebuilderLuc Pattyn27-Feb-08 4:04 
Questiondocking and floating window Pin
algates002724-Feb-08 19:28
algates002724-Feb-08 19:28 
GeneralRe: docking and floating window Pin
John_Adams24-Feb-08 22:04
John_Adams24-Feb-08 22:04 
GeneralInherited ComboBox Pin
Brady Kelly23-Feb-08 23:26
Brady Kelly23-Feb-08 23:26 
GeneralRe: Inherited ComboBox Pin
darkelv24-Feb-08 6:49
darkelv24-Feb-08 6:49 
GeneralRe: Inherited ComboBox Pin
Brady Kelly24-Feb-08 7:19
Brady Kelly24-Feb-08 7:19 
GeneralRe: Inherited ComboBox Pin
Brady Kelly26-Feb-08 1:48
Brady Kelly26-Feb-08 1:48 
GeneralRe: Inherited ComboBox Pin
Ed.Poore24-Feb-08 7:26
Ed.Poore24-Feb-08 7:26 
Generalrichtextboxes Pin
jazy121-Feb-08 21:29
jazy121-Feb-08 21:29 
GeneralRe: richtextboxes Pin
Christian Graus21-Feb-08 23:42
protectorChristian Graus21-Feb-08 23:42 
GeneralRe: richtextboxes [modified] Pin
jazy127-Feb-08 14:36
jazy127-Feb-08 14:36 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.