Ko Takagi

@carazo

Sounds great! Thank you for your great support.

Hi @themeisle,

I have tried the update and confirmed that the query is no longer being called. Excellent!

Thank you for your great support.

Hi @bvytis,

I’m sorry for confusing, but the screenshot I posted was on my test website. Our real website has over 700,000 wp_posts records and over 100,000 media files, and logs showed a slow query of 35.334482 seconds by that query.

For reference, I tried to run the query on our website using the EXPLAIN statement as follows:

$ wp db query "EXPLAIN SELECT post_mime_type, COUNT( * ) AS num_posts FROM wp_posts WHERE post_type = 'attachment' AND post_status != 'trash' AND (post_mime_type LIKE 'image/%') GROUP BY post_mime_type"
+------+-------------+----------+-------+------------------+------------------+---------+------+--------+---------------------------------------------------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+------+-------------+----------+-------+------------------+------------------+---------+------+--------+---------------------------------------------------------------------+
| 1 | SIMPLE | wp_posts | range | type_status_date | type_status_date | 164 | NULL | 136235 | Using index condition; Using where; Using temporary; Using filesort |
+------+-------------+----------+-------+------------------+------------------+---------+------+--------+---------------------------------------------------------------------+

Since post_mime_type doesn’t have an index, Using temporary; Using filesort seems to occur. It could have an impact on performance in a larger website.

I feel like it’s a kind of problem to be ran this query on every request, even if the status isn’t activated in the general settings of this plugin. What do you think?

• This reply was modified 1 year, 8 months ago by Ko Takagi.

Hi @bvytis,

I’m afraid I didn’t try to roll back the previous version, but I have confirmed that the slow query stopped when I deactivated this plugin. Before updating to version 2.6.3, this query did not appear.

Also, the query seems to occur on every request with just installing this plugin, even if the status is not activated in the general settings.
https://snipboard.io/RDeKYL.jpg

Thank you.

Hi @nsinelnikov

Thank you for sharing! I’m looking forward to using the new version.

Hi @nsinelnikov,

Thank you for the reply. I installed the pre-release version and it worked fine. Excellent!

I’d be happy if this version is available soon. Do you have any plan to release this in the near future?

Thanks.

@alexclassroom
I tested this plugin on WordPress 6.1 and updated the header.
Please check it out.

@imzban
I’m afraid this plugin does not have the feature to do bulk translation.

Thank you.

@tridesolutions
I’m afraid that this plugin does not support Marathi because the plugin’s translation engine, Watson Language Translator itself, does not support it.

@lawrenceowen

Thank you for your information.

Actually, I have an opportunity to borrow the cash drawer from my client in the near future. So I’m going to try the printing myself.

I will report back to you when I can test its operation.

@lawrenceowen
Thank you for helping.

I think that a cache drawer support is a lower priority than the other printing features, so it doesn’t need to be on the list for the 2.1 release. But I’m glad to see that it will be supported in the future.

> Currently, the cash drawer should not usually open at all, but if you have enabled buzzer support then it probably will open. This is because cash drawers and buzzers both use the same connector and circuit to drive them.

By the way, the cash drawer opened when printing, even though the buzzer function was disabled in the plugin settings screen. (Actually, I don’t have a cash drawer, and that’s how it worked when my client tried it.)

If I can customize the code to avoid this behavior, would you tell me how to do that?

@lawrenceowen

I really appreciate it. Thanks a million!

@lawrenceowen

Great code! I was able to print 2D barcode.

Thank you so much for your help as always.??

@lawrenceowen

That’s great! I tried it and was able to print QrCode.

I’m grateful to you.

If possible, could you please tell me how to print JAN13 (EAN13) as well?

@lawrenceowen

Thank you for helping.

I’ll look into the way of using SDML that you mentioned.

> I hope, today to be able to provide an example of adding QrCode printing support to the $printer object, which is probably quicker/easier for you?

If you can tell me how to do that as well, that would be great. It might help us solve the problem faster.??

• This reply was modified 3 years, 8 months ago by Ko Takagi.