Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Native DBF or 3part database ?
Message
From
12/12/2007 01:07:23
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01274972
Message ID:
01275041
Views:
16
This message has been marked as the solution to the initial question of the thread.
>I've been using free .dbf tables for long time
>I would not like to use a database as firebird or other
>because it's pretty easy to use the datenvironment cursors,
>I am used to free tables
>
>Do you guys have large table running without the need of migrating
>to a database ?

1. Pure VFP9:
We run here on multimillion tables (16M recs, 1.7GB-tables) without any problem, but... single user.
We also run multiuser on a 1GB 5.5M recs table with 3 user, no problem.
(We have fast hardware here.)
BUT: when running big tables multiuser, you will have to switch to Client-Server techniques. There is only one escape I know of:

2. VFP.NET (Etecnologia-version)
The VFP-version of Etec is able to handle tables from Databases like Oracle, MSSql, MySql as any other free table. That means you can open an Oracle table and do REPLACE FOR ...
It is not known how Etec performs with large pure VFP-tables at this moment.

HTH,

Lennert
Previous
Reply
Map
View

Click here to load this message in the networking platform