General information
Category:
Coding, syntax & commands
>I believe, that's it's fully optimizable, but assuming that
>1. return of significant amount of records,
>2. significant number of joined table,
>3. order clause on result,
>4. main one- functions in result field set (they will fire for each record),
>12 min might be trustworthy.
>I believe you should reconsider your interface approach. As i guess, you use 'membergrid' cursor as Grid.Recordsource. Probably, 115K is not very representative for users, and it would be more appropriate to coleect smaller recordset, e.g. for particular 'ikeyproduct'. Also, it's not necessarily to join all related tables. Instead of this, you could combine two tables, and add some grid.column.buttons to open dialogs (e.g. 'memberdata' dialog).
You have interestings suggestions. Thanks for your help
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only