Hi all, I have a form on which I am having some interesting performance issues, I think, but am not sure that it is my extensive use of SQLSession variables throughout the form. I have a single page data entry form where almost every field gets stored in the SESSION. This form can take from 9 to 15 seconds to display. When all my other forms take 1 to 3 seconds this is a significant slowdown. I am curious as to what methods may be used to reduce calls to SESSION['varname'], or if I am even barking up the right tree. Thanks. -- Stand Fast, tjg. Chief Technology Officer tjg@exceptionalminds.com Red Hat Certified Engineer www.exceptionalminds.com Avalon Technology Group, Inc. (503) 246-3630
>>>>>>Linux...Because rebooting isn't normal<<<<<<<<<<<<
On Thu, 2 Mar 2000, Timothy Grant wrote:
I have a single page data entry form where almost every field gets stored in the SESSION. This form can take from 9 to 15 seconds to display. When all my other forms take 1 to 3 seconds this is a significant slowdown.
I am curious as to what methods may be used to reduce calls to SESSION['varname'], or if I am even barking up the right tree.
Last I checked, setting an SESSIOn variable immediately did an update on the RDBM which would explain the slowdown. I do not know what the current situation is but I remember Anthony mentioning he was thinking of changing it. You might trying playing with the source code and store all changes to SESSION in a volatile attribute and call the SQL method at the end of the transaction only (at least this is how I do it in FSSession). Pavlos
participants (2)
-
Pavlos Christoforou -
Timothy Grant