To prevent the IDX database file from growing massively with Sage X3, you can take several steps to manage and optimize your database usage. Here's a guide on what you can do:
1. Regular Database Maintenance:
Perform regular maintenance tasks on your…
Hi ClarkM and Erzsi_I
I see that that a similar question was posted by slacka 6 months ago, and remains unfixed.
I don't understand why this issue hasn't been taken seriously. This seems to be a critical issue in the way a client is able to, or in…
This article has come from a very experienced colleague in Australia.
Introduction
Microsoft SQL Server 2005 added new system tables to assist in the system reporting. Three of these tables in particular are written to every time a query is run. Microsoft…
I have been finding recently that on certain computers, Crystal Reports will give an error message if I don't uncheck the box “Use indexes or server for speed” in the Report Options. Unchecking this makes the report run much slower.
At one client I…