Обсуждение: adopendynamic
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
R V Sreedharan wrote: > 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 mailimmediately. 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
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é