Devart Forums

Hey.

I am using the new dotConnect for Postgres 4.95.180.0 build.

[Devart]
We have fixed the problem with Unprepared Execute for connections created using DbProviderFactory. The fix will be available in the nearest build, which we plan to release next week.

This seem to have fixed the Unprepared Execute for connections created using DbProviderFactory when Protocol = Ver20. But the problem still exist for when Protocol=Ver30.

[Devart]
The performance problem is caused by the fact that by default Protocol 3 prepares commands before execution. When this preparation is disabled, the performance of Protocol 3 is approximately the same as the one of Protocol 2.

I need a fix for the performance problem when using DbProviderFactory and Protocol = Ver30.

Please run the sample test program you sent me to recreate the problem I am referring too on the latest dotConnect for Postgres version 4.95.180.0

Thanks,

Charlie J.
[/img]

The sample actually had an error: the same command was used for both prepared and unprepared execution. As the UnpreparedExecute property of the connection is set to the command in the constructor of the latter one, the command used in the second test had UnpreparedExecute set to false too.

I've sent you a fixed sample, please check that it was not blocked by your mail filter.

Great. Thanks. Procotol 3 Unprepared Execute=true; gives me the same performance as Procotol 2.

Charlie J.

The problem is back. When I set Unprepared Execute=True in my connection string and use Protocol = Ver30, Postgres is preparing the statements on the Server-Side. This was fixed before. How do I disable Server-Side prepared statements using Protocol=Ver30? I am using DBFactoryProvider to create the connnection in my machine.config.

I've sent you the sample project in a letter. In our environment, the test is run essentially faster when the 'Unprepared Execution' property is set to true. Please specify if you observe some other behaviour.

Put a trace on your Postgres Server. With Unprepared Execute=true and Protocol=Ver30, the trace is showing that the Postgres Server is preparing the statements. So it appear that Unprepared Execute=true is not working.

Any update or reply to the Unprepared Execute=true is not working.

Thanks,

Charlie J.

We couldn't reproduce this issue in our environment. Could you please specify the following:
1) the version of PostgreSQL you are working with;
2) the list of server variables set for this PostgreSQL instance;
3) the exact version (including the build number) of dotConnect for PostgreSQL you are using;
4) the commands you are executing.

If possible, please send us a sample of server logs for the corresponding commands.

We couldn't reproduce this issue in our environment. Could you please specify the following:
1) the version of PostgreSQL you are working with;
5.30.172

2) the list of server variables set for this PostgreSQL instance;
Default Installed Values

3) the exact version (including the build number) of dotConnect for PostgreSQL you are using;
5.30.172 from the Customer Download

4) the commands you are executing.
Just simple inserts

I am using Entity Framework 4.1 and the DBProviderFactory from my machine.config

Could you please specify the version of the PostgreSQL server you are working with?

I've sent you another test project. Please try running it and specify the log generated on the server for the commands executed in this sample.

The Postgres SQL Server is version 8.4.1

We couldn't reproduce the issue on the 8.4.1 server either. Could you please run the sample and specify the logs written for the commands executed in it?

I did not received the sample application your wanted me to run to generate the log. Please email it to [email protected].

Thanks,

Charlie J.

The Unprepared Execute option works only for the PgSqlConnection.CreateCommand method at the moment.
We are working on improvements for this functionality.
As a workaround, I recommend you to add the following code to your context constructor:

Ok. Like I stated I am using EntityFramework with my connectionstring in my web.config and using the DDProviderFactory from the machine.config

The problem is back. When I set Unprepared Execute=True in my connection string and use Protocol = Ver30, Postgres is preparing the statements on the Server-Side. This was fixed before. How do I disable Server-Side prepared statements using Protocol=Ver30? I am using DBFactoryProvider to create the connnection in my machine.config.

I really thought this was working before and got broken again.

So you are saying that my configuration using Entity Framework has never worked and I need to use this workaround to get it to work?

Thanks,

Charlie J.