Information générale
Catégorie:
Gestionnaire d'écran & Écrans
Vladimir,
can you send me the structure, indexes and your SELECT statement
Arnon
> Hello Arnon!
>
> This table is already sorted, but the time of selecting is so slow ;(
And,
> remember, that my query is partially optimized. I tried examples from
VFP
> help that was claimed as fully optimized and get the same results:
> partially or none optimization ;) It's very strange thing.
>
> Have a happy day
> Vladimir Shevchenko
>
> > I can understand why it can take VFP long to copy 800,000 records to a
> new
> > temporary table
> > static data then you might consider SORTing the table on the Indexkey
it
> > can lower the retrieve time dramatically
> >
> > Arnon
> >
> > >Hello Arnon!
> > >
> > >This query may return from 100 till 700-800 thousand records. Don't
> think
> > >that it's bad programming style, just testing of Rushmore power
> against
>
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement