I have a multi-user paradox database application that works over existing LAN connection.
~10 users, 12 tables, 100Kb - 10Mb per table, Delphi & VB applications.
Client now wants WAN support, over multiple site using their existing 1MBit WAN connection.
In a nutshell - What is the best way to achieve this?
- I know multi-user Paradox over WAN is really pushing it (should i start panicking now?)
- The application stores "real-time" information, so ideally information needs to be
- I was thinking some sort of synchronisation method to mirror database changes between sites.
- Does anyone have any data on Paradox file mechanism / bandwidth usage?
Eg. If I append a single record to a remote 10Mb file, does it first read the entire file back & then
- I am presuming re-writing all applications to use a true Client-Server (different) DB would
be a big job.
Is there a 3rd party Client-server driver that can be bolted on to Paradox?
Can FireFox / other royalty-free Client-Server DB quickly replace Paradox implementation?
- If anyone has any experience / solutions of this scenario I would be most grateful.
- Anyone still writing multi-user applications with Paradox?
* Database on server PC, with local VB and delphi service applications read/write data to DB.
* Delphi client applications read data from DB.
* Delphi Database transactions performed using TQuery SQL
* VB Database transactions performed using ADO SQL
* All tables have primary index, simple fields (No maintained secondary indexes / other frills)
* Database integrity monitored with TUTIL32.dll
* Database backup performed with DbiCopyTable calls etc.
Thanks for your comments in advance,