Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can I place a structural .CDX on a different drive?
Message
From
15/02/1999 14:29:16
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Can I place a structural .CDX on a different drive?
Miscellaneous
Thread ID:
00187769
Message ID:
00187769
Views:
52
Is there any way to specify a location for a table's structural .CDX file that's different from the table's location?

I'd like to tweak the performance of a VFP app by using an SQL Server trick: putting the index file on a different drive. I know this can work for a non-structured .CDX, but I'd like to try it with the table's main structured .CDX.

I tried moving a structural .CDX to it's new location and reassociating it with it's table by issuing:

USE myTable INDEX [Different Drive:\Path]\myTable.CDX

But when I closed it and reissued USE without the INDEX option, I got the "Cannot Locate Index" error.(I also retried the above and issued REINDEX, still no dice)

I'm just wondering if there's a .DBC hack or something that would make this possible.

Thanks,

-Bernie
Next
Reply
Map
View

Click here to load this message in the networking platform