dbTalk Databases Forums  

adopendynamic

comp.databases.postgresql.novice comp.databases.postgresql.novice


Discuss adopendynamic in the comp.databases.postgresql.novice forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
R V Sreedharan
 
Posts: n/a

Default adopendynamic - 04-09-2004 , 12:16 AM






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


Reply With Quote
  #2  
Old   
Nabil Sayegh
 
Posts: n/a

Default Re: adopendynamic - 04-10-2004 , 10:56 AM






R V Sreedharan wrote:

Quote:
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.
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



Reply With Quote
  #3  
Old   
Iandé Coutinho
 
Posts: n/a

Default triggers - 04-15-2004 , 01:49 PM



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)


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.