bookkeeping agency
-
Hi to all, i have developed solution for bookkeeping agency. There are a lot of inserts in database (two tables header and details) from many points (10-15-20). Operators are inserted documents with 10-20(50 or 100) items. At the moment, mine solution is insert in database a each row of data as it is comlete and just after insert there is select wich retrive data from database. With this i have data in scope of everyone, but as it is very frequntly it is so SLOW. After each row select(with several 9-10 joins) retrives more and more data. Mine other idea is that operator is working in local and when is finished with a document then to lounch insert in database. With this i will bypass continual rounds throuh server, but data will bee in scope just after inserting whole document ... I need some instructions about solving this bussiness task. I'm working with sql 2000 and vb.net Thanks to all
-
Hi to all, i have developed solution for bookkeeping agency. There are a lot of inserts in database (two tables header and details) from many points (10-15-20). Operators are inserted documents with 10-20(50 or 100) items. At the moment, mine solution is insert in database a each row of data as it is comlete and just after insert there is select wich retrive data from database. With this i have data in scope of everyone, but as it is very frequntly it is so SLOW. After each row select(with several 9-10 joins) retrives more and more data. Mine other idea is that operator is working in local and when is finished with a document then to lounch insert in database. With this i will bypass continual rounds throuh server, but data will bee in scope just after inserting whole document ... I need some instructions about solving this bussiness task. I'm working with sql 2000 and vb.net Thanks to all
-
alexrad wrote:
i have developed solution for bookkeeping agency.
alexrad wrote:
I need some instructions about solving this bussiness task.
Well at least you have selected the appropriate time to consider this... :rolleyes:
led mike