Diese Seite mit anderen teilen ...

Informationen zum Thema:
WinDev Forum
Beiträge im Thema:
Erster Beitrag:
vor 10 Monaten, 2 Wochen
Letzter Beitrag:
vor 10 Monaten, 2 Wochen
Beteiligte Autoren:
Garry Allen, GuenterP, Fabrice Harari

Conflict with Pervasive SQL?

Startbeitrag von Garry Allen am 05.09.2017 15:17

A client asked me if there is any likely conflict with Pervasive SQL. It is used by their Business Solutions accounting software which has been very slow lately. They think that the delay began roughly about the same time that I installed HFSQL C/S on their server for an unrelated app. There does not appear to be any port conflict that I can see but I suggested that they simply shout down the HFSQL server for a short time and see if the performance improves.



it looks like pervasive doesn't like the fact that HFSQL is keping for himself part of the RAM available.
So pervasive cannot cache as much data as before and hop, slower...

So no conflict, just not enough RAM for everybody.

Best regards

von Fabrice Harari - am 05.09.2017 16:24
Hi, no, there's no direct conflict of HFSQL C/S and Pervasive SQL. However, Pervasive SQL and several ERP/Accounting software packages regularly conflict with Btrieve applications. Ask them which port Pervasive is using on their server. As a test, you could change the 4900 port to something else. It may be that their server hardware is simply too old or too slow (e.g. an Intel Atom processor) or has not enough RAM installed.

von GuenterP - am 05.09.2017 16:39
Thanks Fabrice and Guenter. I agree that insufficient memory (8G) is probably the source of the problem.

von Garry Allen - am 05.09.2017 17:26
Zur Information:
MySnip.de hat keinen Einfluss auf die Inhalte der Beiträge. Bitte kontaktieren Sie den Administrator des Forums bei Problemen oder Löschforderungen über die Kontaktseite.
Falls die Kontaktaufnahme mit dem Administrator des Forums fehlschlägt, kontaktieren Sie uns bitte über die in unserem Impressum angegebenen Daten.