Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Binary index problem with a large cursor
Message
From
01/02/2008 10:08:37
 
 
To
31/01/2008 15:25:26
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01287654
Message ID:
01288036
Views:
12
>I have a process that loads about 8 million rows of data from a csv file, massages the data, and subsequently inserts the data into a SQL server table. In an effort to improve performance, I changed an index tag that I build on DELETED() to binary.
>
>The entire process ordinarily takes around four hours from start to finish. I launched it last night around 6:30 PM (against a test server) and found that it was still attempting to build the indices (DELETED() Binary, a Varchar (25), and a couple of integer keys at 9:30 this morning. The cdx in the tmpfiles directory appeared to be a 0 byte file. If memory serves, the cdx is usually several hundred mb.
>
>Obviously, I will retain the regular index on DELETED(). Just wondered if anyone else has run into this.

Haven't experienced it, but it sounds like your index file may have crossed the 2GB file size limit. Maybe you can try creating the binary index into a separate .CDX file?
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform