Ich kann nicht auf eine andere
DB umsteigen,
Access ist nun mal vorgegeben. Es müssen
SQL-Abfragen generiert werden damit mein Chef schneller und übersichtlicher an die Infos kommt, die das alte vorhandene Warenwirtschaftprogramm nicht hergibt. Gibt es für Firedac Verbindung eine performance optimierte Einstellung? Vielleicht kann man irgendwie die
SQL Queries cachen? Was sollte ich noch probieren, die performance insgesamt zu verbessern? Es greifen nur 5 Arbeitsplätze auf die
Access mdb zu.
LG Harry
Hi,
Is by "
Access" you mean MS Office
Access the application and its interface ?
Because if that is what required then Office
Access (also Excel) support
ODBC and you can connect them to almost anything else (ant
DB server/database provider), you are not limited to mdb providers.
Another idea is see if some sort of synchronization is possible with AccessDB and other providers using
ODBC, here the slowness of AccessDB mdb will not kick unless you are doing write from mdb to the other side (you main
DB), otherwise it will be simple insert/update/delete in mdb that will not affect you
DB server, or at least has the minimum impact.
Well, that if i understood this right ?
Or may be you meant you boss
SQL queries needs to be executed fast in robust way (may be they are complex), then do it the other way, first replicate/copy/export/import the mdb to your whatever (
MySQL, MariaDB, MS SqlServer...) and find how fast enough these queries will perform again running them on mdb, evaluate the speed of such marshaling.
Also you still can utilize the
ODBC mentioned above in finding faster and responsive way.
hope that helps.