> De: "sivapostgres"
> Para: "Benedict Holland"
> Cc: "pgsql-general" , "Thomas Kellerer"
>
> Enviadas: Quarta-feira, 17 de fevereiro de 2021 11:09:38
> Assunto: Re: Slow while inserting and retrieval (compared to SQL Server)
> So
On 2021-02-17 12:54:18 +, sivapostg...@yahoo.com wrote:
> Yes, that's what I feel. With no records in any tables, working from the same
> machine where PG has been installed, with only one user working, inserting few
> records (10 records in total, in all 6 tables) should not take this much
>
sivapostg...@yahoo.com schrieb am 17.02.2021 um 14:27:
> We use datawindows. Datawindows will send the required DML
> statements to the database.
> And it sent in format 1 .
>
> IN start of the application, Autocommit set to True.
> Before update of any table(s)
> Autocommit is set to False
> Inse
Yea. Let's see what the metrics actually are. It is possible that the data
gets loaded in instantly but for whatever reason you do t see the reflected
changes.
On Wed, Feb 17, 2021, 9:09 AM sivapostg...@yahoo.com
wrote:
> So far no performance tuning done for sql server. It works fine for the
>
So far no performance tuning done for sql server. It works fine for the load.
Even the express edition which is free, works better. I don't think postgres
will be so slow to insert such a low number of records in an empty database.
I'll be preparing the required sql statements to insert tho
Sql server is a 10k dollar to 1 million dollar application (or more) that
is specifically optimized for windows and had limited to no support
anywhere else. Postgres is free and from my experience, comes within 5% of
any other dbms. Inserting 1 row at a time with auto commit on will be a bit
slow b
We use datawindows. Datawindows will send the required DML statements to the
database. And it sent in format 1 .
IN start of the application, Autocommit set to True.Before update of any
table(s)Autocommit is set to FalseInsert/Update/Delete recordsIf success commit
else rollbackAutocommit i
sivapostg...@yahoo.com schrieb am 17.02.2021 um 13:01:
> To populate some basic data we try to insert few records (max 4
> records) in few tables (around 6 tables) from one window. We feel
> that the insert time taken is longer than the time taken while using
> Sql Server. We tested almost a sim
- Mensagem original -
> De: "sivapostgres"
> Para: "luis.roberto"
> Cc: "pgsql-general"
> Enviadas: Quarta-feira, 17 de fevereiro de 2021 9:54:18
> Assunto: Re: Slow while inserting and retrieval (compared to SQL Server)
> Hello,
&
05:35:43 pm IST,
wrote:
- Mensagem original -
> De: sivapostg...@yahoo.com
> Para: "pgsql-general"
> Enviadas: Quarta-feira, 17 de fevereiro de 2021 9:01:15
> Assunto: Re: Slow while inserting and retrieval (compared to SQL Server)
>
> Hello,
>
> Using
- Mensagem original -
> De: sivapostg...@yahoo.com
> Para: "pgsql-general"
> Enviadas: Quarta-feira, 17 de fevereiro de 2021 9:01:15
> Assunto: Re: Slow while inserting and retrieval (compared to SQL Server)
>
> Hello,
>
> Using Postgres 11 in
Hello,
Using Postgres 11 in Windows Server 2012 & PowerbuilderWorking from the same
machine where Postgres 11 is installed. So no chance for any network issue, I
feel.
No setup/config change done. Just working with all the default settings.With
no data in any of the 179 tables in that databas
12 matches
Mail list logo
