zURLManager / News: Recent posts

If anyone has any tips on whether it is worth moving PL/PgSQL code to native C code, please write to botik32@yahoo.com. Also, I need pointers to general scalability tips for a backend...

The PL/PgSQL code I am pondering is used to build objects from different field tables, and it is slow when asked to return many objects. One solution to that is to create a temporary table to cache returned objects, are there any other techniques? Would rewriting the whole thing to native C using libpq provide a speed tradeoff?... read more