473,388 Members | 1,557 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,388 software developers and data experts.

Tweak postgresql ODBC driver

Hello list

I use postgresql ODBC driver (Version 7.03.02) to access the database
(7.3.4) running on RH8, the connection string is:
DRIVER={PostgreSQL};DATABASE=dbmund;SERVER=192.168 .0.103;PORT=5432;
UID=postgres;PWD=foo;A7=50;A8=8192;USEDECLAREFETCH =1
I would like to know if is there a way to tweak the ODBC driver to get
more speed for querys, I tried to find some docs to know what each ODBC
parameter mean and how could I set them to get a better performance, but
haven't had luck until now. In my scenario, performance slows down over
ODBC.

Thanks in advance,

--
Josué Maldonado.

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 12 '05 #1
0 1868

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Bill J. | last post by:
I have to update a PostgreSQL linked server through MSSQL2K. I first configured the connection with ODBC as follows and I can do queries with no problem: EXEC sp_droplinkedsrvlogin @rmtsrvname...
0
by: Bill J. | last post by:
I have to update a PostgreSQL linked server through MSSQL2K. I first configured the connection with ODBC as follows and I can do queries with no problem: EXEC sp_droplinkedsrvlogin @rmtsrvname...
3
by: Muhyiddin A.M Hayat | last post by:
What Component can I use in Delphi to connect to PostgreSQL?
1
by: fuzzy | last post by:
How cvan i install the postgresql ODBC Driver for Windows if i have only a DLL ? Thanx in Advance
13
by: Zlatko Matiæ | last post by:
Is it possible to use Access as front-end for POstgreSQL and how ? What about Access Projects (.adp) and PostgreSQL ?
3
by: Sim Zacks | last post by:
I have a postgresql backend with an access front end and I am trying to redefine the recordset of the form to use an ADO recordset. The problem is that the CursorType always changes to...
9
by: Jacques Lebastard | last post by:
I have a problem writing PHP ODBC scripts that suit both MySQL and PostgreSQL. So far, the following syntaxes seem to apply to each database (this is an 'insert' example; the same differences apply...
1
by: jesmi | last post by:
on connect to postgresql from datasource administrator following error are displayed: Connection verification failed for data source: record java.sql.SQLException: FATAL: user "system" does not...
5
by: mitrofun63 | last post by:
Hi, All In the first place sorry for mu english. I'm trying to integrate DB2 9.1.3 (with WebSphere Federation Server Relational Wrappers installed) and PostgreSQL 7.4 on SLES9 box I have...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.