i am using sql server 2000 database for navision.
as 5 months have been passed and there is a bulk no of
records are posted.when i go to post any record which is related to
g/l entry or item ledger entry,it iakes a lot of time to post
ie. i am simply posting a expence voucher.it takes near about 10 min. to post on clients,and 5-6 min. in server.I have aptimised all tables.but there
is not much more effect of that.
currently there are 12 lacs records in glentry table.
pls suggest how we can improve the speed.
(Sr. Tech. Consultant)
Dataman Computer Systems (P) Ltd.
mail :[email protected]