I am not a programmer, but have had to use vfp for a while. I'm hoping someone could help me with this indexing question.
I have a table of 7,000 or so records.
I start with a for loop (for x = 1 to 12)
Within the for loop, I create the following index:
index on expected_return tag er for sector_code = x
set order to er
...other code
delete tag er
endfor
The problem is the delete tag takes a long time to delete and go to the next for loop.
I have been trying to figure out a way to "manually" create an index (within an open table)that would have a filter that could change.
For example:
order name: er
type: regular
expression: expected_return
filter: sector_code = x
Problem is since x is not defined it will not save.
Any way to do this?
I suppose since I only have 12 sectors I could create 12 index tags (1 for each sector) but I was hoping there might be another way around doing that.
Also, for a relatively small table, why does it take so long to delete the tag? I am running over a gigabit network.
Thanks
I have a table of 7,000 or so records.
I start with a for loop (for x = 1 to 12)
Within the for loop, I create the following index:
index on expected_return tag er for sector_code = x
set order to er
...other code
delete tag er
endfor
The problem is the delete tag takes a long time to delete and go to the next for loop.
I have been trying to figure out a way to "manually" create an index (within an open table)that would have a filter that could change.
For example:
order name: er
type: regular
expression: expected_return
filter: sector_code = x
Problem is since x is not defined it will not save.
Any way to do this?
I suppose since I only have 12 sectors I could create 12 index tags (1 for each sector) but I was hoping there might be another way around doing that.
Also, for a relatively small table, why does it take so long to delete the tag? I am running over a gigabit network.
Thanks