pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
optimization in C
2+ messages / 1 participants
[nested] [flat]

* optimization in C
@ 2000-08-17 08:45  Jerome Raupach <jraupach@intelcom.fr>
  0 siblings, 0 replies; 2+ messages in thread

From: Jerome Raupach @ 2000-08-17 08:45 UTC (permalink / raw)
  To: pgsql-sql; pgsql-hackers@postgresql.org; pgsql-general@postgresql.org

in C, I work on a database (4 table).

	COPY FROM file ;
	SELECT, INSERT, UPDATE, DELETE for a result in the last 				table.
	COPY TO file ;

in the file, are stored 10000 informations.

-> It's slowly !!!
Can you help me for optimization this?

I didn't use Oid, trigger and function SQL.

Thanks.
Jerome.



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* optimization in C
@ 2000-08-17 13:23  Jerome Raupach <jraupach@intelcom.fr>
  0 siblings, 0 replies; 2+ messages in thread

From: Jerome Raupach @ 2000-08-17 13:23 UTC (permalink / raw)
  To: pgsql-sql

This solution isn't good when there are +10000 tuples in the table, it's
slowly...
anybody can help me ? :


	string = "SELECT service, noeud, rubrique FROM table" ;
	res = PQexec( conn, string.data() ) ;
	if ( (! res) || (status = PQresultStatus( res ) != PGRES_TUPLES_OK) )
	{
		cerr << _ERROR << "Problem SELECT ! " << endl ;
		cerr << _ERROR << "Error : " << PQresStatus( status ) << endl ;
		cerr << _ERROR << "Error : " << PQresultErrorMessage( res ) << endl ;
		PQclear( res ) ;
	}
	else
	{
		for (int m=0; m < PQntuples( res ); m++)
		{
			service = PQgetvalue( resultat1, m, 0 ) ;
			noeud = PQgetvalue( resultat1, m, 1 ) ;
			rubrique = PQgetvalue( resultat1, m, 2 ) ;

			commande = "SELECT SUM(date) FROM table WHERE service='" + service +
"' AND noeud='" + noeud + "' AND rubrique='"+ rubrique + "'" ;
			res1 = PQexec( conn, string.data() ) ;
			if ( (! res1) || (status = PQresultStatus( res1 ) != PGRES_TUPLES_OK)
)
			{
				cerr << _ERROR << "Problem SUM ! " << endl ;
				cerr << _ERROR << "Error : " << PQresStatus( status ) << endl ;
				cerr << _ERROR << "Error : " << PQresultErrorMessage( res1 ) << endl
;
				PQclear( res1 ) ;
			}
			else
			{
				cout << _TRACE << "SUM ok." << endl ;
				PQclear( res1 ) ;
			}
		}
		PQclear( res ) ;
	}

Thanks. jerome.



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2000-08-17 13:23 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-08-17 08:45 optimization in C Jerome Raupach <jraupach@intelcom.fr>
2000-08-17 13:23 optimization in C Jerome Raupach <jraupach@intelcom.fr>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox