Thanks Ken.
Even if it was closer to 10 mins, it sounds real good to me.
Cheers,
Jim N
>Jim,
>
>Well - the group by I originally posted now takes (took) about 5-10 minutes (sorry I didn't actually measure). the reason I have so many records in that size is that my recsize is very small relatively speaking (85).
>
>not sure about the deleted thing. I suspect it's always been there. My own opinion is that I KNOW it works (to speed things up) when doing selects, counts, sums, etc that look at most of the table. I do agree, however, (and now implement this) that it is pretty much irrelevant (and maybe harmful) in most "real" applications where you are narrowing down by other keys/fields already.
>
>Ken
>
>>Hi Ken,
>>
>>Do you mind telling us (me) how long this sucker takes, now that you're 'satisfied'? The reason that I ask is that I have had lots of table at the 2-gig limit but never one with more than 4.5 million or so records.
>>
>>Regards,
>>
>>Jim N
>>
>>PS Do you think that the DELETED() thing has been with us all along or something new (maybe with VFP at the start or maybe even in a subsequent version)?
>>
>>>Stephen,
>>>
>>>2 - things
>>>
>>>1) Much has come out lately about how tags on deleted() can actually hurt - and rarely help - most operations
>>>
>>>2) Since I have SET DELETED OFF - Rushmore would not, could not use the tag anyway - it would be irrelevant
>>>
>>>In any case - I've got it working fine now.
>>>
>>>FYI - this data is for statistical analysis - that's why it's on a local drive - it's 15 MILLION records - not 1.5, though I've recently narrowed that down to about 10 MILLION - not sure what cdx file was since it's been deleted - it was pushing 100M ... dbf was 1.7G
>>>
>>>thanks,
>>>KEn
>>>
>>>>>Hi -
>>>>>
>>>>>turned out that simply re-indexing (or losing indexes!) solved the problem - must have been some hang-up woth that.
>>>>>
>>>>>Just FYI -
>>>>>-data is not on network
>>>>>-SET DELETED IS OFF - so indexing on deleted would be useless (said this one before)
>>>>>
>>>>>thanks!
>>>>>Ken
>>>>
>>>>Rushmore uses that deleted index alot and if not there you could just hurt yourself.
>>>>
>>>>Local access to 1.5 mill transactions is not normal? You should seek help if you consider that "private data" {just joking}
>>>>
>>>>
>>>>What is the size of the cdx file? 5-10 meg?
>>>>
>>>>__Stephen
Previous
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