Board index » delphi » Paradox Tables over network

robbie...@ozemail.com.au

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Paradox Tables over network

Hi there,

Using D4 C/S with Paradox Tables.

This app will be accessing tables across a network. When the app first
starts up, will the entire table/s contents be copied across the
network to the users workstation?

The reason I ask is one of the tables is quite large, mainly because
it has the capacity to hold up to 30 JPEG's per record. This table
will grow in size quite rapidly.

Many thanks in advance

Robbie...

 
Jeff Brow

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Paradox Tables over network


Sort of yes and sort of no.

The table won't be copied at startup, but will probably be read many times
across the network while the application is accessing the table.  This is
because the client application has to process the table locally in order
to extract required data from it, as paradox tables are handled locally by
the BDE, not by a remote database server.

Jeff

Quote
robbie...@ozemail.com.au wrote:
> Hi there,

> Using D4 C/S with Paradox Tables.

> This app will be accessing tables across a network. When the app first
> starts up, will the entire table/s contents be copied across the
> network to the users workstation?

> The reason I ask is one of the tables is quite large, mainly because
> it has the capacity to hold up to 30 JPEG's per record. This table
> will grow in size quite rapidly.

> Many thanks in advance

> Robbie...

Frédéric BROUAR

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Paradox Tables over network


Quote
robbie...@ozemail.com.au wrote:
> Hi there,

> Using D4 C/S with Paradox Tables.

> This app will be accessing tables across a network. When the app first

> starts up, will the entire table/s contents be copied across the
> network to the users workstation?

> The reason I ask is one of the tables is quite large, mainly because
> it has the capacity to hold up to 30 JPEG's per record. This table
> will grow in size quite rapidly.

> Many thanks in advance

> Robbie...

1
The amount of data that will drive on the network will be restricted by
the MAXBUFSIZE parameter in the BDE configuration panel for each table.
2
All BLOBS are not directly receive. They are circulating only when the
user click on the object that will show it.

To be sure, try a test in copying a thousand time the same records
containing the same datas...

You will be surprise by the flexibility of Paradox Table !!

Other Threads

1. Slow Paradox tables on network

2. Using Paradox tables on networks

3. Ho to speed up paradox-tables in network

4. Paradox tables on network

5. Paradox tables on network

6. Paradox tables on network drives

7. Paradox tables on network problem

8. Accessing Paradox-tables in network from Wfw 3.11

9. Q: bde, paradox tables and network = directory busy ???

10. Paradox Table and Network Error