hi all.
we're experiencing a progressive slow down when saving files in swx with dbworks activated, expecially when saving new parts. it's not a matter of network speed, because:
- we've recently upgraded our 100mbit fast ethernet lan to a gigabit lan using a cisco gigabit switch
- the network backup we schedule twice a week is *terribly* fast it isn't either a matter of cpu speed because we've recently moved to new powerful workstations (p4-3.2, 1.5gb, scsi disk, blahblah)
at the moment, we're still using dbworks with a central .mdb access file, as it was set up years ago. the size of the file, after a tools/compact database is something around 16mb and in some weeks grows up to 60mb --or more; yes, i'd like to know what the h**k dbworks does *continuously* on its database--.
the slowdown, as stated, is progressive and going worse and worse. it gets a little bit better after the tools/compact database, but for a very short time.
our file server is a sarge debian linux server, which runs also a postgresql server --which i use for other things--: may i use it for dbworks, too? postgresql has a great odbc driver. i wouldn't want to install a ms2003 server only for dbworks and wouldn't want to pay money for a ms sql server i wouldn't use that much... at the moment i have *no* microsoft servers in my lan --removed them one by one in the past years--.
any suggestions? thank you in advance.
regards,