-
Notifications
You must be signed in to change notification settings - Fork 39
/
_remote.log
61 lines (50 loc) · 1.33 KB
/
_remote.log
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
Python: 3.6.3 | packaged by conda-forge | (default, Nov 4 2017, 10:10:56)
[GCC 4.8.2 20140120 (Red Hat 4.8.2-15)]
PyEXASOL: 0.4.1
PyODBC: 4.0.16
TurbODBC: 2.4.1
Creating random data set for tests, 10000000 rows
Please wait, it may take a few minutes
Test data was prepared
time python 03_pyexasol_fetch.py
real 2m6.109s
user 0m20.151s
sys 0m11.957s
time python 03_pyexasol_fetch.py (with compression=True)
real 1m32.433s
user 0m18.651s
sys 0m6.110s
time python 06_pyexasol_pandas.py
<class 'pandas.core.frame.DataFrame'>
RangeIndex: 10000000 entries, 0 to 9999999
Data columns (total 8 columns):
USER_ID int64
USER_NAME object
REGISTER_DT object
LAST_VISIT_TS object
IS_FEMALE int64
USER_RATING float64
USER_SCORE int64
STATUS object
dtypes: float64(1), int64(3), object(4)
memory usage: 610.4+ MB
real 1m17.030s
user 0m13.039s
sys 0m3.587s
time python 07_pyexasol_pandas_compress.py
<class 'pandas.core.frame.DataFrame'>
RangeIndex: 10000000 entries, 0 to 9999999
Data columns (total 8 columns):
USER_ID int64
USER_NAME object
REGISTER_DT object
LAST_VISIT_TS object
IS_FEMALE int64
USER_RATING float64
USER_SCORE int64
STATUS object
dtypes: float64(1), int64(3), object(4)
memory usage: 610.4+ MB
real 0m28.997s
user 0m13.734s
sys 0m2.454s