Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199508272235.PAA29118@nobozo.CS.Berkeley.EDU>
Sender: owner-postman@postgres.Berkeley.EDU
Date: Sun, 27 Aug 1995 17:35:25 -0500
Message-Id: <199508272235.RAA23176@tristero.io.com>
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
To: postgres@postgres.Berkeley.EDU
From: mskc@io.com (Casey Claiborne)
Subject: slow postgres performance
Resent-To: postgres-redist@postgres.Berkeley.EDU
Resent-Date: Sun, 27 Aug 95 15:35:58 -0700
Resent-XMts: smtp

Hello -
        I had downloaded postgres and am using it on a 486 SX 33Mhz machine
under the Linux 1.2.1 operating system. I am making calls to the postgres
server from "C" code (I am using embedded sql). I have routines such as
db_add_user_info, db_get_user_info, db_delete_user info which are written
very much similar to the one below with the exception that some of the code
and the queries themselves will change. Whenever I run my application using the 
routines the performance is VERY slow. I have not yet added indexes - I do 
not know
if that alone will solve the problem. Is there a *better approach* I can use?

*Any* help is welcomed and appreciated.

TIA

P.S. I had heard of a company that sold postgres and thus would also provide
some support for the product. Does anyone know the name of the company
and how they can be contacted?


Casey


========================= code starts below ================================

My routines look something like the following:

[other code]

typedef user struct_user {
char name[20];
char address[50];
char city[20];
char state[10];
} USER;


[other code]

db_add_user_info(USER user_info)
{
char* res;
char tempdata[600];

sprintf(tempdata, "append user (user.name = \"%s\", user.address=\"%s\", 
user.city=\"%s\", user.state=\"%s\") ",
        user_info.name, user_info.address, user_info.city, user_info.state);

PQsetdb("testdb");
PQexec("begin");

res = PQexec(tempdata);
^^^
[ the return values for PQ exec *do not* work! Whenever I made tests using 
the return code, it was *never* correct ]


if (*res == 'E')
        {
        printf("this did not work 1 \n");
        PQexec("end");
        exit();
        }

if (*res == 'I')
        {
        printf("this did not work 2 \n");
        PQexec("end");
        exit();
        }
PQexec("end");
PQfinish();

[Because the return codes do not work above, I had to add another call to 
the server to test if the row actually went in]

}


One must note the importance of setting reasonable and achievable goals for
                    "If you aim for nothing, you'll hit it every time" 
                               -Theodore Roosevelt


==============================================================================
   To add/remove yourself to/from the POSTGRES mailing list: send mail with 
   the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU".
   If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
   a human will deal with it.  DO NOT post to the "postgres" mailing list.
==============================================================================
              URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/