Hi,
We are developing visual basic application with postgres as back
end.When we open ADODB recordset for particular recorset by using cursor
type as adopendynamic and lock type as adLockBatchOptimistic it takes 15
seconds to execute query,where as the same query when run in postgres
server it takes 3 sec to execute.However when i open the recordset using
cursor type as adopenforwardonly it executes the query within the
fraction of second in same application with postgres as back end.Since
this recordset is used for saving the records i need to use cursor type
as adopendynamic.Table has 40000 records in the postgres dtabase.
How to minimise the record fetching time while using recordset as
adopendynamic with postgres as backend.
Please help me to overcome this problem.

Regards,
RVS.



This e-Mail may contain proprietary and confidential information and is sent for the intended recipient(s) only.
If by an addressing or transmission error this mail has been misdirected to you, you are requested to delete this mail immediately.

visit us at www.vbizap.com



---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

R V Sreedharan wrote:

You shouldn't send confidential information to an open mailing list

SCNR
--
e-Trolley Sayegh & John, Nabil Sayegh
Tel.: 0700 etrolley /// 0700 38765539
Fax.: +49 69 8299381-8
PGP : http://www.e-trolley.de

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Afternoon guys, I would be very gratefull if anyone could help me on this
one. I´ve tried looking for examples on it, i know it´s simple, but i can´t
get one, so here goes. I need to create a trigger(after insert), preferebly
in plpgsql, as I have already created the lang using createlang, that, takes
value from 2 columns of the record it´s inserting, and concatenate together
and insert it into a 3rd column,
for example:

I have a table:

employee

id | branch | name | uniqueId
---|--------|-------|---------

on insert into employee(id,branch,name) values(1,1543,"iande");

the trigger would get both id and branch valeus and insert on uniqueId
so,

select * from employee;

id | branch | name | uniqueId
-----------------------------
1 | 1543 | iande | 15431


thanks in advance;

Iandé






---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)