Title: Database queries
Last modified: December 12, 2023

---

# Database queries

 *  Resolved [aioex](https://wordpress.org/support/users/aioex/)
 * (@aioex)
 * [2 years, 5 months ago](https://wordpress.org/support/topic/database-queries-6/)
 * Hi there,
 * I have a basic question about database queries.
 * We are currently using a plugin that queries all added license keys (over 200,000
   entries) to get a list of available license keys and then find the one to sell
   and process the order.
 * This is impossible for us to keep up with and we would like to know how your 
   plugin handles the database queries when an order should be processed?
 * Our second question is about the API and retrieving license keys using the API.
 * We would like to develop an additional panel that we can connect to your plugin
   via the API, retrieve one or more license keys for a particular software and 
   then mark it as sold. Again, querying the database is really important to us.
 * Finally, we would like to know the number of license keys available per product.
   Is there a way to check this with your plugin?
 * Thank you very much and we look forward to your reply. We are considering buying
   your pro version if your plugin would be optimized.

Viewing 1 replies (of 1 total)

 *  Plugin Support [Mirza Hamza](https://wordpress.org/support/users/hamza1010/)
 * (@hamza1010)
 * [2 years, 5 months ago](https://wordpress.org/support/topic/database-queries-6/#post-17273353)
 * Hello [@aioex](https://wordpress.org/support/users/aioex/),
 * Thanks for contacting us,
 * Hope you are doing well, In our plugin license is assigned to products, and when
   a product is sold out or delivered license key is delivered with the order we
   can search license by order and product both on the licenses page.
 * Yes, we have API that retrieves the license and in our pro version we can also
   retrieve particular software
 * Also, you can know the number of license keys available per product
   these features
   are available in our plugin
 * Thanks & Regards
   WP Experts Support Team
    -  This reply was modified 2 years, 5 months ago by [Mirza Hamza](https://wordpress.org/support/users/hamza1010/).

Viewing 1 replies (of 1 total)

The topic ‘Database queries’ is closed to new replies.

 * ![](https://ps.w.org/license-manager-for-woocommerce/assets/icon-256x256.gif?
   rev=2824216)
 * [License Manager for WooCommerce](https://wordpress.org/plugins/license-manager-for-woocommerce/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/license-manager-for-woocommerce/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/license-manager-for-woocommerce/)
 * [Active Topics](https://wordpress.org/support/plugin/license-manager-for-woocommerce/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/license-manager-for-woocommerce/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/license-manager-for-woocommerce/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [Mirza Hamza](https://wordpress.org/support/users/hamza1010/)
 * Last activity: [2 years, 5 months ago](https://wordpress.org/support/topic/database-queries-6/#post-17273353)
 * Status: resolved