[SQL] optimization in C

2000-08-17 Thread Jerome Raupach
This solution isn't good when there are +1 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) )

[SQL] optimization in C

2000-08-17 Thread Jerome Raupach
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 1 informations. -> It's slowly !!! Can you help me for optimization this? I