FEDEVEL
Platform forum

kyfion , 11-04-2025, 02:35 PM

Is there anyone who can answer me the above question ?

I have so far used excel and access and it seems that every time AD loads component data into the RAM.
It also becomes laggy after adding component into the schematic if huge database library is used.

KInd regards,
Kostas

QDrives , 11-05-2025, 01:37 AM

My experience with MS SQL Express compared to Access for an application I created (nothing electronic) was that Access was faster than SQL Express.
It may have been the connection logic.

kyfion , 11-05-2025, 08:21 AM

@QDrives Did you experience lags between symbols placement in the schematic ? It has become so annoying that I'm thinking about deserting the DBlib setup for my libraries.
In my case I've implemented celestial Altium DB from Issus which has about 230000 components. It is a very refined library with lots of care as it seems.

But I've anticipated laggy behavior in Altium as mentioned above. So far I've converted Issus library from his online SQL DB library into local access DB initially and then into an excel but both ended up with laggy behavior. Now I'm thinking about changing into local hosted SQL DB.

QDrives , 11-05-2025, 09:23 PM

How laggy?
Altium still is not at the AD17 and older level with regards to speed. Even with SchLib containing 50 components it can be slow.

kyfion , 11-06-2025, 07:29 AM

Good morning @QDrives . It is 25-30 seconds.
BUT !! I've figured out why and fixed it. If you have opened the excel at the same time that altium is working due to the dual access in the file Altium starts lagging.

The solution is after modifying the excel file or the access DB to close the file to prevent dual access and laggy behavior. It took me a while to figure it out but i hope it will help someone else in the future.

QDrives , 11-06-2025, 08:58 PM

25...30 seconds is not laggy, that is unresponsive!