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 ?
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.
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.