labview & mysql performance

[Ale914]

Hi

i'm testing LabSQL with mysql 4 due ODBC driver on Windows XP2

I try different types of simple query but i report poor performance

1000 select of INT about 900ms

using Query browser i execute he same query in about 15 ms!

i don't know why, maybe a bug in ODBC.

Do you have any feedback on performance?

Bye,

Alessandro.

[Michael Aivaliotis]

Hi

i'm testing LabSQL with mysql 4 due ODBC driver on Windows XP2

I try different types of simple query but i report poor performance

1000 select of INT about 900ms

using Query browser i execute he same query in about 15 ms!

i don't know why, maybe a bug in ODBC.

Do you have any feedback on performance?

Bye,

Alessandro.

Yes, well this is a known (to me) bottleneck with the LabSQL stuff. There are changes you have to make to some VI's that may speed things up. Here are the two VI's before:

And here are the two VI's after:

[Ale914]

Thank you Michael

i try the modify suggested by you and its work fine.

Now i have 600ms for 1000 select and about 400ms for 1000 update.

Bye,

Alessandro.

[Michael Aivaliotis]

Thank you Michael

i try the modify suggested by you and its work fine.

Now i have 600ms for 1000 select and about 400ms for 1000 update.

Bye,

Alessandro.

That is still slow. What SQL statement are you using? Also, have you indexed your table?

I just did a simple test with: SELECT * FROM `databasename`.`tablename` of 1000 records and it takes: 15ms.

[Ale914]

Michael i don't execute a single select of 1000 rows but 1000 select of one field...sure in the first case i obtain a time of 15 ms similar to your.

The actual performance are good for my needs.

Now my problem is on ADO callback i need to generate a callback when a commit operetion occur on DB.

I wrote this simple VI for register the callback but dosen't work at all (no callback is fire)

Do you have experience on this?

Thanks,

Alessandro.

[Robinson]

That is still slow. What SQL statement are you using? Also, have you indexed your table?

I just did a simple test with: SELECT * FROM `databasename`.`tablename` of 1000 records and it takes: 15ms.

Using the changes mentioned and with the original code when i query for 632 columns i get 4000 rows in about 2-3 mins ....y is that so?? is it bcoz of the number of columns ??

Edited August 5, 2009 by Robinson