I'm doing some server speed optimization for a client running over a VPN.  I've done some
quick and easy changes just by observing the number and type of packets sent via a
sniffer, but now need more detail.  Basically, I want to see a detailed log of database
activity, such as when a table is opened, closed, when a row is requested, posted, etc.
Does this functionality exist somewhere or do I need to get into the server code and mess
around?

Thanks,

Kyle

Kyle,

<< I'm doing some server speed optimization for a client running over a VPN.
I've done some quick and easy changes just by observing the number and type
of packets sent via a sniffer, but now need more detail.  Basically, I want
to see a detailed log of database activity, such as when a table is opened,
closed, when a row is requested, posted, etc. Does this functionality exist
somewhere or do I need to get into the server code and mess around?  >>

It's available, but DBISAM requires that you log this type of information on
the client via the TDBISAMSession.RemoteTrace property and
TDBISAMSession.OnRemoteTrace event:

http://www.elevatesoft.com/dbisam4d7_tdbisamsession_remotetrace.htm
http://www.elevatesoft.com/dbisam4d7_tdbisamsession_onremotetrace.htm

--
Tim Young
Elevate Software
www.elevatesoft.com

<<"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:


It's available, but DBISAM requires that you log this type of information on
the client via the TDBISAMSession.RemoteTrace property and
TDBISAMSession.OnRemoteTrace event:

http://www.elevatesoft.com/dbisam4d7_tdbisamsession_remotetrace.htm
http://www.elevatesoft.com/dbisam4d7_tdbisamsession_onremotetrace.htm

>>

Tim,

That almost does it, but I would like a little more detail, specifically then name(s) of
the table(s) being accessed.  Any suggestions?

Kyle

Kyle Heironimus wrote:

> <<"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:
>
>
> It's available, but DBISAM requires that you log this type of
> information on the client via the TDBISAMSession.RemoteTrace property
> and TDBISAMSession.OnRemoteTrace event:
>
> http://www.elevatesoft.com/dbisam4d7_tdbisamsession_remotetrace.htm
> http://www.elevatesoft.com/dbisam4d7_tdbisamsession_onremotetrace.htm
>
> > >
>
> Tim,
>
> That almost does it, but I would like a little more detail,
> specifically then name(s) of the table(s) being accessed.  Any
> suggestions?
>
> Kyle


Is it a problem to have more than one EXE containing a DBISAMEngine
component running on a single computer?

TIA,

Glynn

--

Kyle,

<< That almost does it, but I would like a little more detail, specifically
then name(s) of the table(s) being accessed.  Any suggestions? >>

Unfortunately, that information isn't available in the remote trace.  Are
you looking for performance data related to queries specifically ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Glynn,

<< Is it a problem to have more than one EXE containing a DBISAMEngine
component running on a single computer? >>

No.

--
Tim Young
Elevate Software
www.elevatesoft.com

Kyle, if you are looking for increased performance why not just use straight TCP/IP, you don't need to use VPN. You can encrypt the TCP/IP communications and you avoid the VPN
overheads.