Jump to content

labview & mysql performance


Recommended Posts

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.

Link to comment
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:

post-2-1138082105.gif?width=400

And here are the two VI's after:

post-2-1138082278.gif?width=400

Link to comment
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. :yes:

Link to comment

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)

post-399-1138206754.jpg?width=400

Do you have experience on this?

Thanks,

Alessandro.

Link to comment
  • 3 years later...

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. yes.gif

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 by Robinson
Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.