How to speed up table access

[Joey Frazee]

I am using VFP6 Service 4. The average table size can be from 200 000 to
800 000 records. With tables this size I am having a hard time on some network
configurations to keep the speed up. Any suggestions would be appreciated.
Thank You.

[Fred Taylor]

What's your SET DELETED setting? Do you have a tag on DELETED()? Certain
combinations of these two items may speed up/slow down your access to these
tables. YMMV.

--
Fred
Microsoft Visual FoxPro MVP
Please respond only to the newsgroups so that all may benefit.


"Joey Frazee" <jafrazee@nb.sympatico.ca> wrote in message
news:3aa43266@news.devx.com...
>
> I am using VFP6 Service 4. The average table size can be from 200 000 to
> 800 000 records. With tables this size I am having a hard time on some
network
> configurations to keep the speed up. Any suggestions would be
appreciated.
> Thank You.

[Joey Frazee]

set deleted() is on
I do not have a tag on deleted.
I do have about 8 different indexes used for reporting but one is only used
for browsing.

"Fred Taylor" <ftaylor@mvps.org> wrote:
>What's your SET DELETED setting? Do you have a tag on DELETED()? Certain
>combinations of these two items may speed up/slow down your access to these
>tables. YMMV.
>
>--
>Fred
>Microsoft Visual FoxPro MVP
>Please respond only to the newsgroups so that all may benefit.
>
>
>"Joey Frazee" <jafrazee@nb.sympatico.ca> wrote in message
>news:3aa43266@news.devx.com...
>>
>> I am using VFP6 Service 4. The average table size can be from 200 000
to
>> 800 000 records. With tables this size I am having a hard time on some
>network
>> configurations to keep the speed up. Any suggestions would be
>appreciated.
>> Thank You.
>
>

[Fred Taylor]

OK, you may need to have a tag on DELETED() if you will have deleted records
in this table, or if you never do, you'll want to have SET DELETED OFF.

--
Fred
Microsoft Visual FoxPro MVP
Please respond only to the newsgroups so that all may benefit.


"Joey Frazee" <jafrazee@nb.sympatico.ca> wrote in message
news:3aa4399c$1@news.devx.com...
>
> set deleted() is on
> I do not have a tag on deleted.
> I do have about 8 different indexes used for reporting but one is only
used
> for browsing.
>
> "Fred Taylor" <ftaylor@mvps.org> wrote:
> >What's your SET DELETED setting? Do you have a tag on DELETED()?
Certain
> >combinations of these two items may speed up/slow down your access to
these
> >tables. YMMV.
> >
> >--
> >Fred
> >Microsoft Visual FoxPro MVP
> >Please respond only to the newsgroups so that all may benefit.
> >
> >
> >"Joey Frazee" <jafrazee@nb.sympatico.ca> wrote in message
> >news:3aa43266@news.devx.com...
> >>
> >> I am using VFP6 Service 4. The average table size can be from 200 000
> to
> >> 800 000 records. With tables this size I am having a hard time on some
> >network
> >> configurations to keep the speed up. Any suggestions would be
> >appreciated.
> >> Thank You.
> >
> >
>

[Dan Freeman]

800K records is chump change for Foxpro.

You don't really say what you're doing and what about it is slow.

Fred already mentioned the tag on DELE() and SET DELE OFF. Can you give us
an idea what's slow?

Dan


Joey Frazee <jafrazee@nb.sympatico.ca> wrote in message
news:3aa43266@news.devx.com...
>
> I am using VFP6 Service 4. The average table size can be from 200 000 to
> 800 000 records. With tables this size I am having a hard time on some
network
> configurations to keep the speed up. Any suggestions would be
appreciated.
> Thank You.

[Joey Frazee jafrazee.nb.sympatico.ca]

"Dan Freeman" <dan@dfapam.com> wrote:
>800K records is chump change for Foxpro.
>
>You don't really say what you're doing and what about it is slow.
>
>Fred already mentioned the tag on DELE() and SET DELE OFF. Can you give
us
>an idea what's slow?
>

>Dan
>
>
>Joey Frazee <jafrazee@nb.sympatico.ca> wrote in message
>news:3aa43266@news.devx.com...
>>
>> I am using VFP6 Service 4. The average table size can be from 200 000
to
>> 800 000 records. With tables this size I am having a hard time on some
>network
>> configurations to keep the speed up. Any suggestions would be
>appreciated.
>> Thank You.
>
>
The point I notice the table access being slow is when I intially use the
table and when navigating an other record. I should have also noted that
the table has 77 fields and the record len is 297, two of the fields are
memo fields but there are no relations set to other tables. As an other
Note the table seem to work fine if running standalone on a the local hard
drive. The problem exists if the table is access from a network drive(NT
service 4)