Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Best DB-Backend
Message
De
11/10/2002 11:37:33
 
 
À
11/10/2002 02:04:29
Information générale
Forum:
Visual Basic
Catégorie:
Bases de données DAO/RDO/ODBC/ADO
Titre:
Divers
Thread ID:
00710187
Message ID:
00710367
Vues:
16
>Greetings!
>
>I've been asked to replace an existing Clipper-based db app with a newer, Windows/VB-based version. The old app used dbf files for its back-end database.
>
>Would it be better if I also "upgrade" the dbf files with an mdb file? I'll be using ADO and ODBC for the connection to a server-located database, where the database file sizes reaches upwards of 100mb per year (annual archiving and extraction prevents further ballooning of the files...)
>
>So in short, do I go with Access mdb, or stay with dbf? Which is better performance-wise for this setup?

Moving to an MDB would be a downgrade of capability and capacities; if you want to migrate away from DBF/DBC functionality, I'd investigate MSDE, which offers a very direct upgrade path to SQL Server in the event that the extra capacities and capabilities are required later. MDBs are just an easy way to hurt both performance and data integrity.
EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
- Firesign Theater


NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC

The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform