Mike Yearwood
Toronto, Ontario, Canada
Information générale
Catégorie:
Gestionnaire d'écran & Écrans
Versions des environnements
Network:
Windows 2008 Server
Wow. How about doing nothing and getting the best speed? Have the called form adopt the data session of the calling form. 3 lines of code. Talk about overkill and waste.
>>I noticed that the debugger did not support peeking into the collection at run time - I usually like to take a look the first time I run something to see if the data looks okay. So I had to write a bit of temp code to iterate through the collection throwing each item into an object so I could take a peek. But overall, I like the concept.
>>
>>Albert
>>
>
>Hi Albert:
>
>If data to be passed is flat (records) and not complex (hierarchical records from different tables), and for fast performance, you can use simple arrays that can be created with Select-SQL, or even can passs arrays (one or more) attached to an object, so you can pass the object reference and from that you can show directly the array data or generate a cursor with INSERT FROM ARRAY syntax. This way you can avoid the complexity of collections and can debug directly too. Arrays are faster than collections.
>
>On the other side, collections of record objects have the adventage that you can reference the fields by their names, and not by their column numbers, like when using arrays, but for more than a few hundred of records arrays are faster.
>
>Best regards.-
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