Re: Cost of Sessions
This is a multi-part message in MIME format.
--------------677B3F4B2F9EE1BF40AA7BA4
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Joseph Kormann wrote:
>
> Hello. Does anyone have or know where I can information on the cost of
> creating a database session? We're using ODS 7.22.UC1 on Solaris 2.5.1
> using ESQL/C.
>
> I'm interested in for time-to-create, memory usage, cpu usage, etc...
>
> Thanks!
> --
> Joseph Kormann
> jkormann@mcs.mds.lmco.com
> Ph:732/450-7126 Fx:732/450-7153
> "For a 50/50 chance, 90% of the time you'll choose wrong." - The Keith
> Axiom
Hi Joseph,
it's not fair to compare different platforms, but I measured
the time for the "CONNECT" statement on NT. NT-client/NT-server.
It took about 200ms.
But I think it's better if you run the test by yourself. I will
attach a small ESQL/C-program.
I have no idea how to measure the CPU-usage for the complete
CONNECT. Some CPU-time is spent for your ESQL/C program and
some time is spent inside the Informix server.
Bye
Stefan Weideneder
--------------677B3F4B2F9EE1BF40AA7BA4
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Content-Disposition: inline; filename="gt.c"
#include <stdio.h>
#include <sys/time.h>
main()
{
struct timeval tv1_s, tv2_s;
gettimeofday( &tv1_s, NULL );
EXEC SQL CONNECT TO "whatever@youwant" AS hhh;
gettimeofday( &tv2_s, NULL );
/* RTFM how to evaluate the timeval structure "timeval" */
printf("My pid is %d\\n", getpid());
system("onstat -g ses");
/* this system call will display the memory needed for your session*/
}
--------------677B3F4B2F9EE1BF40AA7BA4--