[odb-users] application very slow with ODB and PostgreSQL

[Javier Gutierrez]

Hello there,

I am just another user of ODB and not an expert, but maybe you can check 
when deleting and updating specific rows, that you have the 
corresponding indexes for accessing those rows, if you run a manual 
select for the same rows, does it also have delay? Another thing to 
consider is using prepared queries, they speed up the process by having 
the queries already compiled instead of compiling them every time, this 
is explained in the point 4.5 of the manual.

Hope it helps, if not the maintainers of the code surely will help you 
further

Best regards,

Javier

-------- Original Message --------
Subject: [odb-users] application very slow with ODB and PostgreSQL
From: Sandhya Seshagiri <sandhya.seshagiri at tcs.com>
To: odb-users at codesynthesis.com
Date: 3/13/2018 9:30 AM
> Dear Boris,
>
> I have created an desktop application using ODB and PostgreSQL 9.3. My
> application is very slow during insert, update and erase. For example it
> takes nearly 15 seconds to erase and update 100 records. Could you please
> help give your suggestion why am facing such issues?
>
> Thanks & Regards
> Sandhya Seshagiri
> Tata Consultancy Services
> Tata Research Development & Design Centre ,
> 54, Hadapsar Industrial Estate,
> Hadapsar,
> Pune - 411 013,Maharashtra
> India
> Mailto: sandhya.seshagiri at tcs.com
> Website: http://www.tcs.com
> ____________________________________________
> Experience certainty.   IT Services
>                          Business Solutions
>                          Consulting
> ____________________________________________
> =====-----=====-----=====
> 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
>
>