Hi,
I have a split DB with the BE (0.5GB) residing on a network drive. All users have an FE file on their local machine. All machines are at least i5's, mostly i7's with plenty of RAM running on a gigabit network. There are usually around 12 users using the DB simultaneously.
I have been doing a lot of research about how to speed the DB up and have done most of the tricks and tips I have found with only very marginal gains. I have read a number of SQL threads on here but the advice as to whether it gives significant performance benefit seems inconclusive.
Has anyone any experience of a similar setup to mine and whether they have migrated to SQL or other and achieved a significant speed increase?]
Thanks
I have a split DB with the BE (0.5GB) residing on a network drive. All users have an FE file on their local machine. All machines are at least i5's, mostly i7's with plenty of RAM running on a gigabit network. There are usually around 12 users using the DB simultaneously.
I have been doing a lot of research about how to speed the DB up and have done most of the tricks and tips I have found with only very marginal gains. I have read a number of SQL threads on here but the advice as to whether it gives significant performance benefit seems inconclusive.
Has anyone any experience of a similar setup to mine and whether they have migrated to SQL or other and achieved a significant speed increase?]
Thanks