#Personal:Re: [odb-users] application very slow with ODB and PostgreSQL

[Sandhya Seshagiri]

Thanks Boris and Javier for your suggestions.

The problem was due to trigger function i have enabled to sync data in 
another postgres database table. The trigger operation slowed down my 
insertion in to tables. Without trigger, the performance by ODB to update 
and erase is very good.

Thanks,
Sandhya




From:   Boris Kolpackov <boris at codesynthesis.com>
To:     Sandhya Seshagiri <sandhya.seshagiri at tcs.com>
Cc:     odb-users at codesynthesis.com
Date:   13-03-2018 18:57
Subject:        Re: [odb-users] application very slow with ODB and 
PostgreSQL



It is hard to say anything definitive without more details. But to add
to Javier's suggestions (thanks, Javier!), the two common causes of
this are:

1. Large database without proper indexes.

2. Accessing database over slow/high-latency connection.

Boris

=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain 
confidential or privileged information. If you are 
not the intended recipient, any dissemination, use, 
review, distribution, printing or copying of the 
information contained in this e-mail message 
and/or attachments to it are strictly prohibited. If 
you have received this communication in error, 
please notify us by reply e-mail or telephone and 
immediately and permanently delete the message 
and any attachments. Thank you