Mailing-List: contact user-help@ignite.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@ignite.apache.org
Subject: Re: PHP and Apache Ignite - very slow query
To: user@ignite.apache.org
References: <1513067849145-0.post@n6.nabble.com>
 <CALOGAox070wvjkksyon8Hz+OGD851wL6xBFWyQM1CC5gZ4X0Fw@mail.gmail.com>
 <1513086754944-0.post@n6.nabble.com>
From: Wolfram Huesken <woh@m18.io>
Message-ID: <e729961e-7812-7322-fa7a-8cc77423c0bc@m18.io>
Date: Tue, 12 Dec 2017 21:57:35 +0800
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101
 Thunderbird/52.5.0
MIME-Version: 1.0
In-Reply-To: <1513086754944-0.post@n6.nabble.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Language: en-US
Content-Transfer-Encoding: 7bit
archived-at: Tue, 12 Dec 2017 13:57:52 -0000

Hi!

If you don't run both queries from PHP, you cannot really compare the 
results. Running queries from the mysql console means that you don't 
have to establish a connection, which takes quite some time.

You don't have to use ODBC to connect to MySQL, PDO will do a fine job 
and makes your data comparable.

Cheers
Wolfram

On 12/12/2017 21:52, bagsiur wrote:
> Hi and thank you for your answer.
> 
> Im not test mysql with odbc driver and at this moment my goal is to find
> more faster solution like mysql. I know that mysql is working on native
> mysql driver and ODBC is a third-party driver but this is recommended
> solution in official Apache Ignite documentation:
> https://apacheignite.readme.io/v2.0/docs/odbc-driver
> 
> In my simple script SQL query with "limit 60500,10" mean: start with 60500
> record and give me 10 recors. So script print only 10 lines.
> 
> So, my question is still actually. Is it possible to run Apache Ignite with
> ODBC driver to work faster with standard SQL queries then MySQL in standard
> configuration?
> 
> Thanks for reply :)
> 
> 
> 
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>