ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Wolfram Huesken <...@m18.io>
Subject Re: PHP and Apache Ignite - very slow query
Date Tue, 12 Dec 2017 14:18:02 GMT
Sorry, then I got you wrong. In this case your results are of course 
comparable.

Cheers
Wolfram

On 12/12/2017 22:14, bagsiur wrote:
> Maybe Im not explain everythinnk correctly. I run mysql queries by PHP of
> course
> 
> So, one more time:
> 
> I prepare the same database, first db in MySQL and second in Apache Ignite.
> Database have the same size and number of rows (~6 milion rows).
> 
> I prepare the same PHP script (as in my first post) useing PDO to connect.
> Only one difference was beetwen connecting:
> 
> For mysql:
> 
> $mysql = new PDO('mysql:host=localhost;dbname=speed_test', 'root',
> '*********');
> 
> For ignite:
> 
> $ignite = new PDO('odbc:Apache Ignite');
> 
> Here is my /etc/odbc.ini:
> 
> [Apache Ignite]
> description=Apache Ignite
> driver=Apache Ignite
> ADDRESS=127.0.0.1:10800
> 
> And /etc/odbcinst.ini:
> 
> [Apache Ignite]
> Description=Apache Ignite
> Driver=/usr/local/lib/libignite-odbc.so
> Setup=/usr/local/lib/libignite-odbc.so
> DriverODBCVer=03.00
> FileUsage=0
> UsageCount=1
> 
> So, my question I still actually :)
> 
> 
> 
> 
> 
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
> 

-- 
Wolfram Huesken
27 Paya Lebar Road
#11-03 Paya Lebar Residences
Paya Lebar 409042
Singapore

Mobile (SG): +65-96464190
Mobile (TH): +66-98-837-7748
E-Mail: woh@m18.io

Mime
View raw message