Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Indexing problems
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00659871
Message ID:
00661011
Views:
22
Also Jon if you can see the indexes going through the table also look at

SET ODOMETER TO [nRecords]

try settinr it for 100 so you screen only gets updated every 100 records and your pc can focus on the job at hand


>Stephen,
>
>Thanks for the tip but I don't think this is the issue. The foreground and background buffer sizes are 358,875,136 and 89,915,392 respectively. That seems like more than enough as far as I'm concerned. And, like I said in the little command window utility I wrote I didn't do a thing with SYS(3050) and it reindexes like a charm.
>
>Any other ideas??
>
>Jon
>
>
>>Hello Jon
>>
>>I would look at SYS(3050)
>>
>>it's a memory buffer size, 90% of the time the smaller the memory buffer the faster things move
>>
>>
>>>I'm having a weird problem with VFP7 on one particular machine and was curious if there's a way to remedy it without having to reinstall:
>>>
>>>When attempting to reindex tables from within VFP the process is either going VERY slowly or not running at all - it takes up some CPU time in the task manager. If I try the exact same operation in a little command window utility I wrote, I see all the keys get regenerated and the indexing is done within seconds.
>>>
>>>Would anyone know what setting needs to be tweaked in order to get this working properly from within VFP's IDE?
>>>
>>>Laterness,
>>>Jon
Stephen McLaughlin
"Sexy Steve Valenteno", "Blastmaster"
stephenmclaughlin@gmail.com
Previous
Reply
Map
View

Click here to load this message in the networking platform