General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
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?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only