Mike Yearwood
Toronto, Ontario, Canada
Information générale
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
>Why are you doing that? Don't have an index and the table is ALWAYS in RECNO() order.
He's adding records that are meant to be between other records, and wants to produce a result as if they were physically sorted.
>
>
>>Processing performance has increased tremendiously. But one another issue has been created.
>>Since the file size or Data is too huge sorting records by RECNO() in a cursor is taking a long time.
>>
>>In other words my processing time has decreased but the time taken for builting a Cursor using RECNO() as sort key and again at the end ordering it in sorkey takes a lot time.
>>
>>Ultimaltely the effective time of entire process has not significantly decreased, though after creation of cursor the process is very very fast.
Précédent
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