Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Practical DBF/DBC Limits In Theory?
I made a little .exe which is busy inserting unique integer values into a free .DBF (two columns iValue and iDel). I plan to use the .DBF with the VFP OLEDB driver to use unique values in some ASP apps - when a page needs a unique value it will do an Application.Lock and SQL-Select the value and then SQL-Update the column to delete it and then Application.Unlock. This is for a low-concurrency application so the Application.Un/Lock isn't a big deal.
When the .exe is done (maybe in 3 days, this is a slow desktop), it will have 100,000,000 rows in it. Has anyone used OLEDB or ODBC for query/update on a DBF of this size? I've never used anything of this size so I don't know what kind of corruption issues I might see.
Anyone?
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement