searches slowing downvdb5.5 files

I am trying to keep this old vdb app running until conversion is complete.

In the program you have the ability to search records by ticket# serial# or
item# all of these searches are running at a snails pace.
 I have tried to reindex the files this ha not helped.

jim wrote:
> I am trying to keep this old vdb app running until conversion is complete.
> 
> In the program you have the ability to search records by ticket# serial# or
item# all of these searches are running at a snails pace.
>  I have tried to reindex the files this ha not helped.
> what next?

What are you using to search? What command specifically?

Ken

-- 
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/

*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/GSP
http://www.goldenstag.net/dbase/dBASEBooks.htm

In article <TjH$6Q7UIHA.1236@news-server>, jimlsc2000@yahoo.com says...
> I am trying to keep this old vdb app running until conversion is complete.
> 
> In the program you have the ability to search records by ticket# serial# or
item# all of these searches are running at a snails pace.
>  I have tried to reindex the files this ha not helped.
> what next?
 

Jim,

Are these dBASE tables? How big are these tables? Are they stored on the 
local PC or on a file server? Are there are lot of people adding, 
changing or deleting rows at the same time? Can you show us some of your 
search code?

-- 
Geoff Wass [dBVIPS]
Montréal, Québec, Canada

.|.|.|        dBASE info at http://geocities.com/geoff_wass       |.|.|.
.|.|.| ---------------------------------------------------------- |.|.|.

The item history table contains 2,632,681 records, the search pulls from this
table for all three criteria. The search didnot start slowing down until the
other day. The only changes that were made to the records was that the date on
some records was incorrect.
Geoff Wass [dBVIPS] Wrote:

> In article <TjH$6Q7UIHA.1236@news-server>, jimlsc2000@yahoo.com
says...
> > I am trying to keep this old vdb app running until conversion is
complete.
> > 
> > In the program you have the ability to search records by ticket#
serial# or item# all of these searches are running at a snails pace.
> >  I have tried to reindex the files this ha not helped.
> > what next?
>  
> 
> Jim,
> 
> Are these dBASE tables? How big are these tables? Are they stored on the 
> local PC or on a file server? Are there are lot of people adding, 
> changing or deleting rows at the same time? Can you show us some of your 
> search code?
> 
> -- 
> Geoff Wass [dBVIPS]
> Montréal, Québec, Canada
> 
> .|.|.|        dBASE info at http://geocities.com/geoff_wass       |.|.|.
> .|.|.| ---------------------------------------------------------- |.|.|.
> .|.|.|             IT Consultant http://Geoff_Wass.com            |.|.|.

In article <mE8CsVIVIHA.1348@news-server>, jimlsc2000@yahoo.com says...
> The item history table contains 2,632,681 records, the search pulls from
this table for all three criteria. The search didnot start slowing down until
the other day. The only changes that were made to the records was that the 
date on some records was incorrect.
> Geoff Wass [dBVIPS] Wrote:


Jim,

2.6 million is a pretty large number. Has anything else changed? What 
version of Windows is it? Do indexes exist for all three fields? What 
about some of my other questions:

Are these dBASE tables? Are they stored on the 
local PC or on a file server? Are there are lot of people adding, 
changing or deleting rows at the same time? Can you show us some of your 
search code?

-- 
Geoff Wass [dBVIPS]
Montréal, Québec, Canada

.|.|.|        dBASE info at http://geocities.com/geoff_wass       |.|.|.
.|.|.| ---------------------------------------------------------- |.|.|.