Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Need optimization ideas
Message
 
 
À
14/09/2003 05:52:53
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00828770
Message ID:
00828832
Vues:
10
>Hi Nadya,
>
>it is a INNER JOIN matching.
>
>1. Solution ( code optimization), reverse JOIN order:
>Search comma-delimited list of codes into the array using ASCAN() function.
>

Hi Fabio,

Yes, I was thinking in this direction, but the code is going to be much more complicated. First I need to parse the string, then since I'm using VFP6, do some special procedures in ASCAN to ensure the correct column, etc. So, the question is: is it worth the trouble. I guess, I have to program and compare speed difference in instantiating the form.

>2. Solution ( implementation optimization), define a index:
>use ItemId on ListBox like a index for codes.
>
Don't understand this idea. Would you please elaborate?
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform