Best practice
Posted: Tue 27 Mar 2007 08:42
Hello,
When a user starts a program I only need to fecth one record (example: select userid and some additional information). This information will not be changed during the session. (read only)
Is there a (performance) difference between:
1. storing the select result in local variables (record type) and close the Table/Sql or StoredProc
2. using data aware components like Table/Sql/StoredProc and display the information with DBEdit-controls and keeping the table active/open
Please let me know......
Eduard
BTW thanks for all the previous answers
When a user starts a program I only need to fecth one record (example: select userid and some additional information). This information will not be changed during the session. (read only)
Is there a (performance) difference between:
1. storing the select result in local variables (record type) and close the Table/Sql or StoredProc
2. using data aware components like Table/Sql/StoredProc and display the information with DBEdit-controls and keeping the table active/open
Please let me know......
Eduard
BTW thanks for all the previous answers