I used to use DBISAM-Admin utility to alter session lengths to stop my apps timing out when users were inactive in certain situations. I can see that I have control of this in the EDBEngine component. Can I override this application-level value through something like the EDBMgr?

What if a user is running a version of an app with sessiontimeout of 180 & I want to override this as a DBA ... is it possible?

--

I have also discovered the ServerSessionStatistics table ... which is another little gold-mine. What is the meaning of the "hits" "misses" & other columns?

Bump?

Adam,

<< I used to use DBISAM-Admin utility to alter session lengths to stop my
apps timing out when users were inactive in certain situations. I can see
that I have control of this in the EDBEngine component. Can I override this
application-level value through something like the EDBMgr? >>

Currently, configuration information like this must be done on the server,
either directly in the edbsrvr.ini file, or via the server's user interface.
I'm working on adding a web interface that will allow for modifying this
type of information via a browser instead.

<< What if a user is running a version of an app with sessiontimeout of 180
& I want to override this as a DBA ... is it possible? >>

Do you mean the session timeout on the server, like above, or the session
timeout on the client side ?

<< I have also discovered the ServerSessionStatistics table ... which is
another little gold-mine. What is the meaning of the "hits" "misses" & other
columns? >>

Hits are how many times a buffer was requested and it was found in the
buffers already present in the buffer manager.  Misses are how many times it
was *not* found, and thus incurred a read from disk.  The Hit Ratio is the
ratio of these two values - the higher the ratio, the better performance
will be.

--
Tim Young
Elevate Software
www.elevatesoft.com

Adam,

Sorry, been working my butt off on some new stuff, and haven't been spending
much time on the newsgroups.  Always remember that you can send me an email
directly, so you don't have to wait so long.  You can even just send me an
email saying "Hey Tim, look at the newsgroups".

--
Tim Young
Elevate Software
www.elevatesoft.com

>>Currently, configuration information like this must be done on the server,
>>either directly in the edbsrvr.ini file, or via the server's user interface.

That's clear.

>>I'm working on adding a web interface that will allow for modifying this
>>type of information via a browser instead.

This would be really useful.

>>Hits are how many times a buffer was requested and it was found in the
>>buffers already present in the buffer manager.  Misses are how many times it
>>was *not* found, and thus incurred a read from disk.  The Hit Ratio is the
>>ratio of these two values - the higher the ratio, the better performance
>>will be.

Phew ... I will wrap my head around that & try to figure it out. This "buffer manager" ... is it something I have any control over as a programmer (is it part of the engine, or the OS?) right now performance is really good, so I don't have to tinker too much to get it better, but if I need to tweek it in the future I will come back to this.

>>Sorry, been working my butt off on some new stuff, and haven't been spending
>>much time on the newsgroups.  

Sounds interesting ...

Tim

>You can even just send me an
>email saying "Hey Tim, look at the newsgroups".

Hmmm I think I'll automate one of those to send every hour on the hour

Roy Lambert

Adam,

<< Phew ... I will wrap my head around that & try to figure it out. This
"buffer manager" ... is it something I have any control over as a programmer
(is it part of the engine, or the OS?) right now performance is really good,
so I don't have to tinker too much to get it better, but if I need to tweek
it in the future I will come back to this. >>

It's part of the engine, and you're correct - if the performance is good,
then you don't need to bother with it.  If the performance is bad, then this
is a good place to look since you'll see that things like complete table
scans cause the number of reads (and misses) to shoot up.

--
Tim Young
Elevate Software
www.elevatesoft.com