|
hi guys , i have made a project that has 5 forms , it's automation project and is doing the regular job of the automation , like adding,deleting,updating and refreshing , im using devcomponent dll in all the forms , but the problem here when i insert 60 record into the database (access database) after i insert the 60th record the program will fall in slumation view , when i want to add a record i should wait 5 sec after i insert a record and if other form is open and wanted to close it the hole program will stop responding for 5 or 7 sec .
i think the big reason for that its using the devcomponent . i dont know maybe the reason is sth else .
so any solution for making the program work faster ?
and one more thing , i cannot change the devcomponents form to normal form.
i dont know if you get what i mean or not ?
|
|
|
|
|
Nope, didn't understand a thing!
Sorry, but I understand each word, but put together like that I didn't understand any of the sentences...
If you get an email telling you that you can catch Swine Flu from tinned pork then just delete it. It's Spam.
|
|
|
|
|
I have never used devcomponents but I assume they are the same as anything else - if you need to run a procedure that is going to take more than a few milliseconds you should launch a thread (look at the BackgroundWorker possibly) to do it on so the UI's thread doesn't lock.
|
|
|
|
|
nice solution , but is this problem is regular in automation programs ?
i mean get really slow/slow when the size of the data get increased ?
|
|
|
|
|
Not necessarily but it depends on how you code the data access stuff. Poor code, poor data validation etc or caching/displaying a lot of data is always going to be slow. Good code and only caching/displaying a sensible amount of data at once will be fast - all other things being equal.
|
|
|
|