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/

Reply via email to