Date: Mon, 27 Aug 2012 00:17:26 -0700 (PDT)
From: lomi...@gmail.com
To: pyodbc@googlegroups.com
Message-Id: <e62c8778-d08e-4093-bfc9-dba127746ae1@googlegroups.com>
Subject: pyodbc very slow when compiled from source (very fast when using
distribution binary)
MIME-Version: 1.0
Content-Type: multipart/mixed;
boundary="----=_Part_24_17771311.1346051846389"
------=_Part_24_17771311.1346051846389
Content-Type: multipart/alternative;
boundary="----=_Part_25_14440115.1346051846389"
------=_Part_25_14440115.1346051846389
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
Hi,
I am trying to compile pyodbc from source (to be able to use a more recent=
=20
version than the one on the official distribution repo).
Compiling under Mint, the resulting pyodbc is extremely slow. Compiling=20
under Ubuntu there does not seem to be an issue. Using the official binary=
=20
from Mint is fast enough, although it is outdated (version 2.1.7).
I compared the compiler and version for Ubuntu and Mint, they are the same=
=20
(gcc (Ubuntu/Linaro 4.6.3-1ubuntu5) 4.6.3), and the output of the=20
compilation are identical.
Would anyone know of what could cause this or if something could help?
The tests and numbers are as follow:
- I am using pyodbc versus Vertica, an analytics platform with an odbc=
=20
backend. This is load optimized database, which has an equivalent of the=
=20
mysql 'LOAD DATA INFILE', which is what I am interested in now.
- To be sure the issue is with pyodbc I ran the following tests, using a=
=20
15GB file:
- dd if=3Dtest.csv of=3D/dev/null =3D> 3 minutes, meaning that readin=
g from=20
disk is fast enough
- using the binary client instead of odbc =3D> 14MB/s of bandwidth,=
=20
meaning that Vertica can handle it
- using isql instead of pyodbc =3D> 14MB/s of bandwidth, meaning that=
=20
odbc can handle it
- using the distribution pyodbc =3D> 14MB/s of bandwidth, meaning tha=
t=20
pyodbc could handle it
- using my own pyodbc : =3D> 300kB/s meaning that there is an issue
=20
The output of my pip install is as follow:
(adwords)guillaume@D116 ~/dwh/dwh/etl/adwords_importer $ pip install pyodbc
Downloading/unpacking pyodbc
Using download cache from=20
/home/guillaume/.pip_download_cache/http%3A%2F%2Fpyodbc.googlecode.com%2Ffi=
les%2Fpyodbc-3.0.6.zip
Running setup.py egg_info for package pyodbc
=20
warning: no files found matching 'tests/*'
Installing collected packages: pyodbc
Running setup.py install for pyodbc
building 'pyodbc' extension
gcc -pthread -fno-strict-aliasing -DNDEBUG -g -fwrapv -O2 -Wall=20
-Wstrict-prototypes -fPIC -DPYODBC_VERSION=3D3.0.6 -I/usr/include/python2.7=
=20
-c /home/guillaume/.virtualenvs/adwords/build/pyodbc/src/sqlwchar.cpp -o=20
build/temp.linux-x86_64-2.7/home/guillaume/.virtualenvs/adwords/build/pyodb=
c/src/sqlwchar.o=20
-Wno-write-strings
cc1plus: warning: command line option =E2=80=98-Wstrict-prototypes=E2=
=80=99 is valid=20
for Ada/C/ObjC but not for C++ [enabled by default]
gcc -pthread -fno-strict-aliasing -DNDEBUG -g -fwrapv -O2 -Wall=20
-Wstrict-prototypes -fPIC -DPYODBC_VERSION=3D3.0.6 -I/usr/include/python2.7=
=20
-c /home/guillaume/.virtualenvs/adwords/build/pyodbc/src/pyodbcdbg.cpp -o=
=20
build/temp.linux-x86_64-2.7/home/guillaume/.virtualenvs/adwords/build/pyodb=
c/src/pyodbcdbg.o=20
-Wno-write-strings
cc1plus: warning: command line option =E2=80=98-Wstrict-prototypes=E2=
=80=99 is valid=20
for Ada/C/ObjC but not for C++ [enabled by default]
gcc -pthread -fno-strict-aliasing -DNDEBUG -g -fwrapv -O2 -Wall=20
-Wstrict-prototypes -fPIC -DPYODBC_VERSION=3D3.0.6 -I/usr/include/python2.7=
=20
-c /home/guillaume/.virtualenvs/adwords/build/pyodbc/src/row.cpp -o=20
build/temp.linux-x86_64-2.7/home/guillaume/.virtualenvs/adwords/build/pyodb=
c/src/row.o=20
-Wno-write-strings
cc1plus: warning: command line option =E2=80=98-Wstrict-prototypes=E2=
=80=99 is valid=20
for Ada/C/ObjC but not for C++ [enabled by default]
gcc -pthread -fno-strict-aliasing -DNDEBUG -g -fwrapv -O2 -Wall=20
-Wstrict-prototypes -fPIC -DPYODBC_VERSION=3D3.0.6 -I/usr/include/python2.7=
=20
-c /home/guillaume/.virtualenvs/adwords/build/pyodbc/src/connection.cpp -o=
=20
build/temp.linux-x86_64-2.7/home/guillaume/.virtualenvs/adwords/build/pyodb=
c/src/connection.o=20
-Wno-write-strings
cc1plus: warning: command line option =E2=80=98-Wstrict-prototypes=E2=
=80=99 is valid=20
for Ada/C/ObjC but not for C++ [enabled by default]
gcc -pthread -fno-strict-aliasing -DNDEBUG -g -fwrapv -O2 -Wall=20
-Wstrict-prototypes -fPIC -DPYODBC_VERSION=3D3.0.6 -I/usr/include/python2.7=
=20
-c /home/guillaume/.virtualenvs/adwords/build/pyodbc/src/cnxninfo.cpp -o=20
build/temp.linux-x86_64-2.7/home/guillaume/.virtualenvs/adwords/build/pyodb=
c/src/cnxninfo.o=20
-Wno-write-strings
cc1plus: warning: command line option =E2=80=98-Wstrict-prototypes=E2=
=80=99 is valid=20
for Ada/C/ObjC but not for C++ [enabled by default]
gcc -pthread -fno-strict-aliasing -DNDEBUG -g -fwrapv -O2 -Wall=20
-Wstrict-prototypes -fPIC -DPYODBC_VERSION=3D3.0.6 -I/usr/include/python2.7=
=20
-c /home/guillaume/.virtualenvs/adwords/build/pyodbc/src/errors.cpp -o=20
build/temp.linux-x86_64-2.7/home/guillaume/.virtualenvs/adwords/build/pyodb=
c/src/errors.o=20
-Wno-write-strings
cc1plus: warning: command line option =E2=80=98-Wstrict-prototypes=E2=
=80=99 is valid=20
for Ada/C/ObjC but not for C++ [enabled by default]
gcc -pthread -fno-strict-aliasing -DNDEBUG -g -fwrapv -O2 -Wall=20
-Wstrict-prototypes -fPIC -DPYODBC_VERSION=3D3.0.6 -I/usr/include/python2.7=
=20
-c /home/guillaume/.virtualenvs/adwords/build/pyodbc/src/params.cpp -o=20
build/temp.linux-x86_64-2.7/home/guillaume/.virtualenvs/adwords/build/pyodb=
c/src/params.o=20
-Wno-write-strings
cc1plus: warning: command line option =E2=80=98-Wstrict-prototypes=E2=
=80=99 is valid=20
for Ada/C/ObjC but not for C++ [enabled by default]
gcc -pthread -fno-strict-aliasing -DNDEBUG -g -fwrapv -O2 -Wall=20
-Wstrict-prototypes -fPIC -DPYODBC_VERSION=3D3.0.6 -I/usr/include/python2.7=
=20
-c /home/guillaume/.virtualenvs/adwords/build/pyodbc/src/getdata.cpp -o=20
build/temp.linux-x86_64-2.7/home/guillaume/.virtualenvs/adwords/build/pyodb=
c/src/getdata.o=20
-Wno-write-strings
cc1plus: warning: command line option =E2=80=98-Wstrict-prototypes=E2=
=80=99 is valid=20
for Ada/C/ObjC but not for C++ [enabled by default]
gcc -pthread -fno-strict-aliasing -DNDEBUG -g -fwrapv -O2 -Wall=20
-Wstrict-prototypes -fPIC -DPYODBC_VERSION=3D3.0.6 -I/usr/include/python2.7=
=20
-c /home/guillaume/.virtualenvs/adwords/build/pyodbc/src/pyodbcmodule.cpp=
=20
-o=20
build/temp.linux-x86_64-2.7/home/guillaume/.virtualenvs/adwords/build/pyodb=
c/src/pyodbcmodule.o=20
-Wno-write-strings
cc1plus: warning: command line option =E2=80=98-Wstrict-prototypes=E2=
=80=99 is valid=20
for Ada/C/ObjC but not for C++ [enabled by default]
gcc -pthread -fno-strict-aliasing -DNDEBUG -g -fwrapv -O2 -Wall=20
-Wstrict-prototypes -fPIC -DPYODBC_VERSION=3D3.0.6 -I/usr/include/python2.7=
=20
-c /home/guillaume/.virtualenvs/adwords/build/pyodbc/src/buffer.cpp -o=20
build/temp.linux-x86_64-2.7/home/guillaume/.virtualenvs/adwords/build/pyodb=
c/src/buffer.o=20
-Wno-write-strings
cc1plus: warning: command line option =E2=80=98-Wstrict-prototypes=E2=
=80=99 is valid=20
for Ada/C/ObjC but not for C++ [enabled by default]
gcc -pthread -fno-strict-aliasing -DNDEBUG -g -fwrapv -O2 -Wall=20
-Wstrict-prototypes -fPIC -DPYODBC_VERSION=3D3.0.6 -I/usr/include/python2.7=
=20
-c /home/guillaume/.virtualenvs/adwords/build/pyodbc/src/cursor.cpp -o=20
build/temp.linux-x86_64-2.7/home/guillaume/.virtualenvs/adwords/build/pyodb=
c/src/cursor.o=20
-Wno-write-strings
cc1plus: warning: command line option =E2=80=98-Wstrict-prototypes=E2=
=80=99 is valid=20
for Ada/C/ObjC but not for C++ [enabled by default]
gcc -pthread -fno-strict-aliasing -DNDEBUG -g -fwrapv -O2 -Wall=20
-Wstrict-prototypes -fPIC -DPYODBC_VERSION=3D3.0.6 -I/usr/include/python2.7=
=20
-c /home/guillaume/.virtualenvs/adwords/build/pyodbc/src/pyodbccompat.cpp=
=20
-o=20
build/temp.linux-x86_64-2.7/home/guillaume/.virtualenvs/adwords/build/pyodb=
c/src/pyodbccompat.o=20
-Wno-write-strings
cc1plus: warning: command line option =E2=80=98-Wstrict-prototypes=E2=
=80=99 is valid=20
for Ada/C/ObjC but not for C++ [enabled by default]
g++ -pthread -shared -Wl,-O1 -Wl,-Bsymbolic-functions=20
-Wl,-Bsymbolic-functions -Wl,-z,relro=20
build/temp.linux-x86_64-2.7/home/guillaume/.virtualenvs/adwords/build/pyodb=
c/src/sqlwchar.o=20
build/temp.linux-x86_64-2.7/home/guillaume/.virtualenvs/adwords/build/pyodb=
c/src/pyodbcdbg.o=20
build/temp.linux-x86_64-2.7/home/guillaume/.virtualenvs/adwords/build/pyodb=
c/src/row.o=20
build/temp.linux-x86_64-2.7/home/guillaume/.virtualenvs/adwords/build/pyodb=
c/src/connection.o=20
build/temp.linux-x86_64-2.7/home/guillaume/.virtualenvs/adwords/build/pyodb=
c/src/cnxninfo.o=20
build/temp.linux-x86_64-2.7/home/guillaume/.virtualenvs/adwords/build/pyodb=
c/src/errors.o=20
build/temp.linux-x86_64-2.7/home/guillaume/.virtualenvs/adwords/build/pyodb=
c/src/params.o=20
build/temp.linux-x86_64-2.7/home/guillaume/.virtualenvs/adwords/build/pyodb=
c/src/getdata.o=20
build/temp.linux-x86_64-2.7/home/guillaume/.virtualenvs/adwords/build/pyodb=
c/src/pyodbcmodule.o=20
build/temp.linux-x86_64-2.7/home/guillaume/.virtualenvs/adwords/build/pyodb=
c/src/buffer.o=20
build/temp.linux-x86_64-2.7/home/guillaume/.virtualenvs/adwords/build/pyodb=
c/src/cursor.o=20
build/temp.linux-x86_64-2.7/home/guillaume/.virtualenvs/adwords/build/pyodb=
c/src/pyodbccompat.o=20
-lodbc -o build/lib.linux-x86_64-2.7/pyodbc.so
=20
warning: no files found matching 'tests/*'
Successfully installed pyodbc
Cleaning up...
Thanks,
Guillaume
------=_Part_25_14440115.1346051846389
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Hi,<br><br>I am trying to compile pyodbc from source (to be able to use a m=
ore recent version than the one on the official distribution repo).<br>Comp=
iling under Mint, the resulting pyodbc is extremely slow. Compiling under U=
buntu there does not seem to be an issue. Using the official binary from Mi=
nt is fast enough, although it is outdated (version 2.1.7).<br>I compared t=
he compiler and version for Ubuntu and Mint, they are the same (gcc (Ubuntu=
/Linaro 4.6.3-1ubuntu5) 4.6.3), and the output of the compilation are ident=
ical.<br><br>Would anyone know of what could cause this or if something cou=
ld help?<br><br><br>The tests and numbers are as follow:<br><ul><li>I am us=
ing pyodbc versus Vertica, an analytics platform with an odbc backend. This=
is load optimized database, which has an equivalent of the mysql 'LOAD DAT=
A INFILE', which is what I am interested in now.<br></li><li>To be sure the=
issue is with pyodbc I ran the following tests, using a 15GB file:</li><ul=
><li>dd if=3Dtest.csv of=3D/dev/null =3D> 3 minutes, meaning that readin=
g from disk is fast enough</li><li>using the binary client instead of odbc =
=3D> 14MB/s of bandwidth, meaning that Vertica can handle it</li><li>usi=
ng isql instead of pyodbc =3D> 14MB/s of bandwidth, meaning that odbc ca=
n handle it</li><li>using the distribution pyodbc =3D> 14MB/s of bandwid=
th, meaning that pyodbc could handle it</li><li>using my own pyodbc : =3D&g=
t; 300kB/s meaning that there is an issue<br></li></ul></ul><br>The output =
of my pip install is as follow:<br><br><span style=3D"font-family: courier =
new,monospace;">(adwords)guillaume@D116 ~/dwh/dwh/etl/adwords_importer $ pi=
p install pyodbc</span><br style=3D"font-family: courier new,monospace;"><s=
pan style=3D"font-family: courier new,monospace;">Downloading/unpacking pyo=
dbc</span><br style=3D"font-family: courier new,monospace;"><span style=3D"=
font-family: courier new,monospace;"> Using download cache from /home=
/guillaume/.pip_download_cache/http%3A%2F%2Fpyodbc.googlecode.com%2Ffiles%2=
Fpyodbc-3.0.6.zip</span><br style=3D"font-family: courier new,monospace;"><=
span style=3D"font-family: courier new,monospace;"> Running setup.py =
egg_info for package pyodbc</span><br style=3D"font-family: courier new,mon=
ospace;"><span style=3D"font-family: courier new,monospace;"> &n=
bsp; </span><br style=3D"font-family: courier new,monospace;"><span style=
=3D"font-family: courier new,monospace;"> warning: no fil=
es found matching 'tests/*'</span><br style=3D"font-family: courier new,mon=
ospace;"><span style=3D"font-family: courier new,monospace;">Installing col=
lected packages: pyodbc</span><br style=3D"font-family: courier new,monospa=
ce;"><span style=3D"font-family: courier new,monospace;"> Running set=
up.py install for pyodbc</span><br style=3D"font-family: courier new,monosp=
ace;"><span style=3D"font-family: courier new,monospace;">  =
; building 'pyodbc' extension</span><br style=3D"font-family: courier new,m=
onospace;"><span style=3D"font-family: courier new,monospace;"> =
gcc -pthread -fno-strict-aliasing -DNDEBUG -g -fwrapv -O2 -Wall -Wst=
rict-prototypes -fPIC -DPYODBC_VERSION=3D3.0.6 -I/usr/include/python2.7 -c =
/home/guillaume/.virtualenvs/adwords/build/pyodbc/src/sqlwchar.cpp -o build=
/temp.linux-x86_64-2.7/home/guillaume/.virtualenvs/adwords/build/pyodbc/src=
/sqlwchar.o -Wno-write-strings</span><br style=3D"font-family: courier new,=
monospace;"><span style=3D"font-family: courier new,monospace;">  =
; cc1plus: warning: command line option =E2=80=98-Wstrict-prototypes=
=E2=80=99 is valid for Ada/C/ObjC but not for C++ [enabled by default]</spa=
n><br style=3D"font-family: courier new,monospace;"><span style=3D"font-fam=
ily: courier new,monospace;"> gcc -pthread -fno-strict-al=
iasing -DNDEBUG -g -fwrapv -O2 -Wall -Wstrict-prototypes -fPIC -DPYODBC_VER=
SION=3D3.0.6 -I/usr/include/python2.7 -c /home/guillaume/.virtualenvs/adwor=
ds/build/pyodbc/src/pyodbcdbg.cpp -o build/temp.linux-x86_64-2.7/home/guill=
aume/.virtualenvs/adwords/build/pyodbc/src/pyodbcdbg.o -Wno-write-strings</=
span><br style=3D"font-family: courier new,monospace;"><span style=3D"font-=
family: courier new,monospace;"> cc1plus: warning: comman=
d line option =E2=80=98-Wstrict-prototypes=E2=80=99 is valid for Ada/C/ObjC=
but not for C++ [enabled by default]</span><br style=3D"font-family: couri=
er new,monospace;"><span style=3D"font-family: courier new,monospace;">&nbs=
p; gcc -pthread -fno-strict-aliasing -DNDEBUG -g -fwrapv -O2 -W=
all -Wstrict-prototypes -fPIC -DPYODBC_VERSION=3D3.0.6 -I/usr/include/pytho=
n2.7 -c /home/guillaume/.virtualenvs/adwords/build/pyodbc/src/row.cpp -o bu=
ild/temp.linux-x86_64-2.7/home/guillaume/.virtualenvs/adwords/build/pyodbc/=
src/row.o -Wno-write-strings</span><br style=3D"font-family: courier new,mo=
nospace;"><span style=3D"font-family: courier new,monospace;"> &=
nbsp; cc1plus: warning: command line option =E2=80=98-Wstrict-prototypes=E2=
=80=99 is valid for Ada/C/ObjC but not for C++ [enabled by default]</span><=
br style=3D"font-family: courier new,monospace;"><span style=3D"font-family=
: courier new,monospace;"> gcc -pthread -fno-strict-alias=
ing -DNDEBUG -g -fwrapv -O2 -Wall -Wstrict-prototypes -fPIC -DPYODBC_VERSIO=
N=3D3.0.6 -I/usr/include/python2.7 -c /home/guillaume/.virtualenvs/adwords/=
build/pyodbc/src/connection.cpp -o build/temp.linux-x86_64-2.7/home/guillau=
me/.virtualenvs/adwords/build/pyodbc/src/connection.o -Wno-write-strings</s=
pan><br style=3D"font-family: courier new,monospace;"><span style=3D"font-f=
amily: courier new,monospace;"> cc1plus: warning: command=
line option =E2=80=98-Wstrict-prototypes=E2=80=99 is valid for Ada/C/ObjC =
but not for C++ [enabled by default]</span><br style=3D"font-family: courie=
r new,monospace;"><span style=3D"font-family: courier new,monospace;"> =
; gcc -pthread -fno-strict-aliasing -DNDEBUG -g -fwrapv -O2 -Wa=
ll -Wstrict-prototypes -fPIC -DPYODBC_VERSION=3D3.0.6 -I/usr/include/python=
2.7 -c /home/guillaume/.virtualenvs/adwords/build/pyodbc/src/cnxninfo.cpp -=
o build/temp.linux-x86_64-2.7/home/guillaume/.virtualenvs/adwords/build/pyo=
dbc/src/cnxninfo.o -Wno-write-strings</span><br style=3D"font-family: couri=
er new,monospace;"><span style=3D"font-family: courier new,monospace;">&nbs=
p; cc1plus: warning: command line option =E2=80=98-Wstrict-prot=
otypes=E2=80=99 is valid for Ada/C/ObjC but not for C++ [enabled by default=
]</span><br style=3D"font-family: courier new,monospace;"><span style=3D"fo=
nt-family: courier new,monospace;"> gcc -pthread -fno-str=
ict-aliasing -DNDEBUG -g -fwrapv -O2 -Wall -Wstrict-prototypes -fPIC -DPYOD=
BC_VERSION=3D3.0.6 -I/usr/include/python2.7 -c /home/guillaume/.virtualenvs=
/adwords/build/pyodbc/src/errors.cpp -o build/temp.linux-x86_64-2.7/home/gu=
illaume/.virtualenvs/adwords/build/pyodbc/src/errors.o -Wno-write-strings</=
span><br style=3D"font-family: courier new,monospace;"><span style=3D"font-=
family: courier new,monospace;"> cc1plus: warning: comman=
d line option =E2=80=98-Wstrict-prototypes=E2=80=99 is valid for Ada/C/ObjC=
but not for C++ [enabled by default]</span><br style=3D"font-family: couri=
er new,monospace;"><span style=3D"font-family: courier new,monospace;">&nbs=
p; gcc -pthread -fno-strict-aliasing -DNDEBUG -g -fwrapv -O2 -W=
all -Wstrict-prototypes -fPIC -DPYODBC_VERSION=3D3.0.6 -I/usr/include/pytho=
n2.7 -c /home/guillaume/.virtualenvs/adwords/build/pyodbc/src/params.cpp -o=
build/temp.linux-x86_64-2.7/home/guillaume/.virtualenvs/adwords/build/pyod=
bc/src/params.o -Wno-write-strings</span><br style=3D"font-family: courier =
new,monospace;"><span style=3D"font-family: courier new,monospace;"> &=
nbsp; cc1plus: warning: command line option =E2=80=98-Wstrict-prototy=
pes=E2=80=99 is valid for Ada/C/ObjC but not for C++ [enabled by default]</=
span><br style=3D"font-family: courier new,monospace;"><span style=3D"font-=
family: courier new,monospace;"> gcc -pthread -fno-strict=
-aliasing -DNDEBUG -g -fwrapv -O2 -Wall -Wstrict-prototypes -fPIC -DPYODBC_=
VERSION=3D3.0.6 -I/usr/include/python2.7 -c /home/guillaume/.virtualenvs/ad=
words/build/pyodbc/src/getdata.cpp -o build/temp.linux-x86_64-2.7/home/guil=
laume/.virtualenvs/adwords/build/pyodbc/src/getdata.o -Wno-write-strings</s=
pan><br style=3D"font-family: courier new,monospace;"><span style=3D"font-f=
amily: courier new,monospace;"> cc1plus: warning: command=
line option =E2=80=98-Wstrict-prototypes=E2=80=99 is valid for Ada/C/ObjC =
but not for C++ [enabled by default]</span><br style=3D"font-family: courie=
r new,monospace;"><span style=3D"font-family: courier new,monospace;"> =
; gcc -pthread -fno-strict-aliasing -DNDEBUG -g -fwrapv -O2 -Wa=
ll -Wstrict-prototypes -fPIC -DPYODBC_VERSION=3D3.0.6 -I/usr/include/python=
2.7 -c /home/guillaume/.virtualenvs/adwords/build/pyodbc/src/pyodbcmodule.c=
pp -o build/temp.linux-x86_64-2.7/home/guillaume/.virtualenvs/adwords/build=
/pyodbc/src/pyodbcmodule.o -Wno-write-strings</span><br style=3D"font-famil=
y: courier new,monospace;"><span style=3D"font-family: courier new,monospac=
e;"> cc1plus: warning: command line option =E2=80=98-Wstr=
ict-prototypes=E2=80=99 is valid for Ada/C/ObjC but not for C++ [enabled by=
default]</span><br style=3D"font-family: courier new,monospace;"><span sty=
le=3D"font-family: courier new,monospace;"> gcc -pthread =
-fno-strict-aliasing -DNDEBUG -g -fwrapv -O2 -Wall -Wstrict-prototypes -fPI=
C -DPYODBC_VERSION=3D3.0.6 -I/usr/include/python2.7 -c /home/guillaume/.vir=
tualenvs/adwords/build/pyodbc/src/buffer.cpp -o build/temp.linux-x86_64-2.7=
/home/guillaume/.virtualenvs/adwords/build/pyodbc/src/buffer.o -Wno-write-s=
trings</span><br style=3D"font-family: courier new,monospace;"><span style=
=3D"font-family: courier new,monospace;"> cc1plus: warnin=
g: command line option =E2=80=98-Wstrict-prototypes=E2=80=99 is valid for A=
da/C/ObjC but not for C++ [enabled by default]</span><br style=3D"font-fami=
ly: courier new,monospace;"><span style=3D"font-family: courier new,monospa=
ce;"> gcc -pthread -fno-strict-aliasing -DNDEBUG -g -fwra=
pv -O2 -Wall -Wstrict-prototypes -fPIC -DPYODBC_VERSION=3D3.0.6 -I/usr/incl=
ude/python2.7 -c /home/guillaume/.virtualenvs/adwords/build/pyodbc/src/curs=
or.cpp -o build/temp.linux-x86_64-2.7/home/guillaume/.virtualenvs/adwords/b=
uild/pyodbc/src/cursor.o -Wno-write-strings</span><br style=3D"font-family:=
courier new,monospace;"><span style=3D"font-family: courier new,monospace;=
"> cc1plus: warning: command line option =E2=80=98-Wstric=
t-prototypes=E2=80=99 is valid for Ada/C/ObjC but not for C++ [enabled by d=
efault]</span><br style=3D"font-family: courier new,monospace;"><span style=
=3D"font-family: courier new,monospace;"> gcc -pthread -f=
no-strict-aliasing -DNDEBUG -g -fwrapv -O2 -Wall -Wstrict-prototypes -fPIC =
-DPYODBC_VERSION=3D3.0.6 -I/usr/include/python2.7 -c /home/guillaume/.virtu=
alenvs/adwords/build/pyodbc/src/pyodbccompat.cpp -o build/temp.linux-x86_64=
-2.7/home/guillaume/.virtualenvs/adwords/build/pyodbc/src/pyodbccompat.o -W=
no-write-strings</span><br style=3D"font-family: courier new,monospace;"><s=
pan style=3D"font-family: courier new,monospace;"> cc1plu=
s: warning: command line option =E2=80=98-Wstrict-prototypes=E2=80=99 is va=
lid for Ada/C/ObjC but not for C++ [enabled by default]</span><br style=3D"=
font-family: courier new,monospace;"><span style=3D"font-family: courier ne=
w,monospace;"> g++ -pthread -shared -Wl,-O1 -Wl,-Bsymboli=
c-functions -Wl,-Bsymbolic-functions -Wl,-z,relro build/temp.linux-x86_64-2=
.7/home/guillaume/.virtualenvs/adwords/build/pyodbc/src/sqlwchar.o build/te=
mp.linux-x86_64-2.7/home/guillaume/.virtualenvs/adwords/build/pyodbc/src/py=
odbcdbg.o build/temp.linux-x86_64-2.7/home/guillaume/.virtualenvs/adwords/b=
uild/pyodbc/src/row.o build/temp.linux-x86_64-2.7/home/guillaume/.virtualen=
vs/adwords/build/pyodbc/src/connection.o build/temp.linux-x86_64-2.7/home/g=
uillaume/.virtualenvs/adwords/build/pyodbc/src/cnxninfo.o build/temp.linux-=
x86_64-2.7/home/guillaume/.virtualenvs/adwords/build/pyodbc/src/errors.o bu=
ild/temp.linux-x86_64-2.7/home/guillaume/.virtualenvs/adwords/build/pyodbc/=
src/params.o build/temp.linux-x86_64-2.7/home/guillaume/.virtualenvs/adword=
s/build/pyodbc/src/getdata.o build/temp.linux-x86_64-2.7/home/guillaume/.vi=
rtualenvs/adwords/build/pyodbc/src/pyodbcmodule.o build/temp.linux-x86_64-2=
.7/home/guillaume/.virtualenvs/adwords/build/pyodbc/src/buffer.o build/temp=
.linux-x86_64-2.7/home/guillaume/.virtualenvs/adwords/build/pyodbc/src/curs=
or.o build/temp.linux-x86_64-2.7/home/guillaume/.virtualenvs/adwords/build/=
pyodbc/src/pyodbccompat.o -lodbc -o build/lib.linux-x86_64-2.7/pyodbc.so</s=
pan><br style=3D"font-family: courier new,monospace;"><span style=3D"font-f=
amily: courier new,monospace;"> </span><br style=3D"font-=
family: courier new,monospace;"><span style=3D"font-family: courier new,mon=
ospace;"> warning: no files found matching 'tests/*'</spa=
n><br style=3D"font-family: courier new,monospace;"><span style=3D"font-fam=
ily: courier new,monospace;">Successfully installed pyodbc</span><br style=
=3D"font-family: courier new,monospace;"><span style=3D"font-family: courie=
r new,monospace;">Cleaning up...</span><br style=3D"font-family: courier ne=
w,monospace;"><br><br>Thanks,<br>Guillaume<br>
------=_Part_25_14440115.1346051846389--
------=_Part_24_17771311.1346051846389--
Message from discussion pyodbc very slow when compiled from source (very fast when using distribution binary)
| Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy |
| ©2013 Google |