Filter don't work, i dont now why, if i change to checkbox, selectbox, multiselect, the table is broken, and normal text / number / etc. no matching records...
Please tell me how was this table created? If it was created with an SQL Query, could you please show me that query?
Also, if it is a table created with an SQL Query - can you please open a ticket in the "wpDatTables" section, as "Pre-Purchase" is reserved for questions posted before purchase, and SQL query based tables are not included in the Lite version of the plugin.
( SELECT name FROM wpps_terms LEFT JOIN wpps_term_taxonomy ON ( wpps_term_taxonomy.term_id = wpps_terms.term_id ) LEFT JOIN wpps_term_relationships ON ( wpps_term_relationships.term_taxonomy_id = wpps_terms.term_id ) WHERE taxonomy = 'pa_brand' AND wpps_term_relationships.object_id = wpps_posts.ID LIMIT 1 ) AS Brand,
(SELECT MIN(meta_value) FROM wpps_postmeta WHERE meta_key='cf_versionmodel' AND post_id = ID) AS Model,
(SELECT MIN(meta_value) FROM wpps_postmeta WHERE meta_key='cf_fueltype' AND post_id = ID) AS FuelType,
( SELECT MIN(meta_value) FROM wpps_postmeta WHERE meta_key='_weight' AND post_id = ID) AS Weight,
(SELECT MIN(meta_value) FROM wpps_postmeta WHERE meta_key='cf_power' AND post_id = ID) AS Power_hp,
(SELECT MIN(meta_value) FROM wpps_postmeta WHERE meta_key='cf_torque' AND post_id = ID) AS Torque,
ROUND((SELECT ((Power_hp / Weight) * 100) AS testp), 2) AS PW,
ROUND((SELECT ((Torque / Weight) * 100) AS test), 2) AS TW,
(SELECT MIN(meta_value) FROM wpps_postmeta WHERE meta_key='cf_accelerations' AND post_id = ID) AS Accelerations,
(SELECT MIN(meta_value) FROM wpps_postmeta WHERE meta_key='cf_luggagevolumenormal' AND post_id = ID) AS Luggage,
(SELECT MIN(meta_value) FROM wpps_postmeta WHERE meta_key='cf_fuelgasconsum' AND post_id = ID) AS FuelConsumption,
'x' AS StartFilters,
(SELECT MIN(meta_value) FROM wpps_postmeta WHERE meta_key='cf_co2efficiencyclass' AND post_id = ID) AS Co2consum,
(SELECT MIN(meta_value) FROM wpps_postmeta WHERE meta_key='cf_bodytype' AND post_id = ID) AS BodyType,
(SELECT MIN(meta_value) FROM wpps_postmeta WHERE meta_key='cf_noofdoors' AND post_id = ID) AS NofDoors,
(SELECT MIN(meta_value) FROM wpps_postmeta WHERE meta_key='cf_noofseat' AND post_id = ID) AS NofSeats,
(SELECT MIN(meta_value) FROM wpps_postmeta WHERE meta_key='cf_noofseatmax' AND post_id = ID) AS NofSeatsMax,
(SELECT MIN(meta_value) FROM wpps_postmeta WHERE meta_key='cf_drivetrain' AND post_id = ID) AS Drivetrain,
(SELECT MIN(meta_value) FROM wpps_postmeta WHERE meta_key='cf_gearboxtype' AND post_id = ID) AS GearboxType,
(SELECT MIN(meta_value) FROM wpps_postmeta WHERE meta_key='cf_noofgears' AND post_id = ID) AS NoofGears,
(SELECT MIN(meta_value) FROM wpps_postmeta WHERE meta_key='cf_noofgears' AND post_id = ID) AS NoofGears,
(SELECT MIN(meta_value) FROM wpps_postmeta WHERE meta_key='_price' AND post_id = ID) AS PriceEur,
(SELECT MIN(meta_value) FROM wpps_postmeta WHERE meta_key='cf_capacityccm' AND post_id = ID) AS Capacityccm,
(SELECT MIN(meta_value) FROM wpps_postmeta WHERE meta_key='cf_length' AND post_id = ID) AS LengthCar
FROM wpps_posts WHERE post_type = 'product' AND post_status = 'publish'
If your MySQL-query based wpDataTable doesn’t work correctly with server-side processing, probably this is happening because wpDataTables server has problems with parsing of the query and building new queries dynamically (rarely happens, but does sometimes). To avoid this please prepare a MySQL view (a stored query), which will return the data that you need, call it e.g. “view1” and then build a wpDataTabled based on a simple query like “SELECT * FROM view1″.
Please note some this when working with the server-side processing feature:
Please do not use “LIMIT” in the SELECT statement. wpDataTables adds it automatically and it will be overridden.
Please do not use “ORDER BY” in the SELECT statement. wpDataTables has its own sorting engine so it makes no sense to use MySQL’s sorting, since it will be overridden. Also, server-side processing feature adds this part of statement automatically when users trigger the sorting on the front-end, and having it in initial statement may cause the table to crash.
Please note that using sub-queries when creating a view may not work if you have PHP version less than 5.7
( SELECT name FROM wpps_terms LEFT JOIN wpps_term_taxonomy ON ( wpps_term_taxonomy.term_id = wpps_terms.term_id ) LEFT JOIN wpps_term_relationships ON ( wpps_term_relationships.term_taxonomy_id = wpps_terms.term_id ) WHERE taxonomy = 'pa_brand' AND wpps_term_relationships.object_id = wpps_posts.ID LIMIT 1 ) AS Brand,
(SELECT MIN(meta_value) FROM wpps_postmeta WHERE meta_key='cf_versionmodel' AND post_id = ID) AS Model,
(SELECT MIN(meta_value) FROM wpps_postmeta WHERE meta_key='cf_fueltype' AND post_id = ID) AS FuelType,
( SELECT MIN(meta_value) FROM wpps_postmeta WHERE meta_key='_weight' AND post_id = ID) AS Weight,
(SELECT MIN(meta_value) FROM wpps_postmeta WHERE meta_key='cf_power' AND post_id = ID) AS Power_hp,
(SELECT MIN(meta_value) FROM wpps_postmeta WHERE meta_key='cf_torque' AND post_id = ID) AS Torque,
ROUND((SELECT ((Power_hp / Weight) * 100) AS testp), 2) AS PW,
ROUND((SELECT ((Torque / Weight) * 100) AS test), 2) AS TW,
(SELECT MIN(meta_value) FROM wpps_postmeta WHERE meta_key='cf_accelerations' AND post_id = ID) AS Accelerations,
(SELECT MIN(meta_value) FROM wpps_postmeta WHERE meta_key='cf_luggagevolumenormal' AND post_id = ID) AS Luggage,
(SELECT MIN(meta_value) FROM wpps_postmeta WHERE meta_key='cf_fuelgasconsum' AND post_id = ID) AS FuelConsumption,
'x' AS StartFilters,
(SELECT MIN(meta_value) FROM wpps_postmeta WHERE meta_key='cf_co2efficiencyclass' AND post_id = ID) AS Co2consum,
(SELECT MIN(meta_value) FROM wpps_postmeta WHERE meta_key='cf_bodytype' AND post_id = ID) AS BodyType,
(SELECT MIN(meta_value) FROM wpps_postmeta WHERE meta_key='cf_noofdoors' AND post_id = ID) AS NofDoors,
(SELECT MIN(meta_value) FROM wpps_postmeta WHERE meta_key='cf_noofseat' AND post_id = ID) AS NofSeats,
(SELECT MIN(meta_value) FROM wpps_postmeta WHERE meta_key='cf_noofseatmax' AND post_id = ID) AS NofSeatsMax,
(SELECT MIN(meta_value) FROM wpps_postmeta WHERE meta_key='cf_drivetrain' AND post_id = ID) AS Drivetrain,
(SELECT MIN(meta_value) FROM wpps_postmeta WHERE meta_key='cf_gearboxtype' AND post_id = ID) AS GearboxType,
(SELECT MIN(meta_value) FROM wpps_postmeta WHERE meta_key='cf_noofgears' AND post_id = ID) AS NoofGears,
(SELECT MIN(meta_value) FROM wpps_postmeta WHERE meta_key='_price' AND post_id = ID) AS PriceEur,
(SELECT MIN(meta_value) FROM wpps_postmeta WHERE meta_key='cf_capacityccm' AND post_id = ID) AS Capacityccm,
(SELECT MIN(meta_value) FROM wpps_postmeta WHERE meta_key='cf_length' AND post_id = ID) AS LengthCar
FROM wpps_posts WHERE post_type = 'product' AND post_status = 'publish'"
Please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.
Loading speed usually depends on the Server performance, and your hosting plan, along with the size of the table. How many rows do you have in that table? How big it is?
I don't know if VPS has good enough performance to achieve that, but it sounds like it won't perform well.
We've tested the plugin for millions of rows, and it performs OK when the server, and hosting plan are good. You can connect that database as a Separate DB connection on our sandbox site, and it should perform better.
Gonzales may help by deactivating some scripts, but significantly increasing the performance is not guaranteed with this plugin.
Like I said - your table consists of 2.9 million entries (cells), and to successfully filter it, the plugin needs to go through the entire table, which does take a long time. On localhost it works a lot faster, but it still takes a minute to filter through the first value. After that it works almost instantly.
Please try duplicating your website on our sandbox site, and you'll see a significant increase in performance.
For a table with 2.9 million entries, it will never be instant I'm afraid.
Since you opened the ticket in pre-purchase section, I cannot say whether you're still in the "15-day money back guarantee" period, but if you are you can log into our store http://store.tms-plugins.com/ with the credentials you received when you purchased the plugin, navigate to Purchases/wpDataTables, and you'll see "Request Refund" button.
Filter don't work, i dont now why, if i change to checkbox, selectbox, multiselect, the table is broken, and normal text / number / etc. no matching records...
Here is video with problem: https://drive.google.com/file/d/1BZDQ1lZl60nhu2sY-9F-Z_SPXG0sq2I6/view
http://fxfbiz.info/
Hello Madalin
Thank you for reaching out to us.
Please tell me how was this table created? If it was created with an SQL Query, could you please show me that query?
Also, if it is a table created with an SQL Query - can you please open a ticket in the "wpDatTables" section, as "Pre-Purchase" is reserved for questions posted before purchase, and SQL query based tables are not included in the Lite version of the plugin.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
SELECT
(
SELECT name
FROM wpps_terms
LEFT JOIN wpps_term_taxonomy ON (
wpps_term_taxonomy.term_id = wpps_terms.term_id
)
LEFT JOIN wpps_term_relationships ON (
wpps_term_relationships.term_taxonomy_id = wpps_terms.term_id
)
WHERE taxonomy = 'pa_brand' AND wpps_term_relationships.object_id = wpps_posts.ID
LIMIT 1
) AS Brand,
(SELECT MIN(meta_value)
FROM wpps_postmeta
WHERE meta_key='cf_versionmodel' AND post_id = ID) AS Model,
(SELECT MIN(meta_value)
FROM wpps_postmeta
WHERE meta_key='cf_fueltype' AND post_id = ID) AS FuelType,
(
SELECT MIN(meta_value)
FROM wpps_postmeta
WHERE meta_key='_weight' AND post_id = ID) AS Weight,
(SELECT MIN(meta_value)
FROM wpps_postmeta
WHERE meta_key='cf_power' AND post_id = ID) AS Power_hp,
(SELECT MIN(meta_value)
FROM wpps_postmeta
WHERE meta_key='cf_torque' AND post_id = ID) AS Torque,
ROUND((SELECT ((Power_hp / Weight) * 100) AS testp), 2) AS PW,
ROUND((SELECT ((Torque / Weight) * 100) AS test), 2) AS TW,
(SELECT MIN(meta_value)
FROM wpps_postmeta
WHERE meta_key='cf_accelerations' AND post_id = ID) AS Accelerations,
(SELECT MIN(meta_value)
FROM wpps_postmeta
WHERE meta_key='cf_luggagevolumenormal' AND post_id = ID) AS Luggage,
(SELECT MIN(meta_value)
FROM wpps_postmeta
WHERE meta_key='cf_fuelgasconsum' AND post_id = ID) AS FuelConsumption,
'x' AS StartFilters,
(SELECT MIN(meta_value)
FROM wpps_postmeta
WHERE meta_key='cf_co2efficiencyclass' AND post_id = ID) AS Co2consum,
(SELECT MIN(meta_value)
FROM wpps_postmeta
WHERE meta_key='cf_bodytype' AND post_id = ID) AS BodyType,
(SELECT MIN(meta_value)
FROM wpps_postmeta
WHERE meta_key='cf_noofdoors' AND post_id = ID) AS NofDoors,
(SELECT MIN(meta_value)
FROM wpps_postmeta
WHERE meta_key='cf_noofseat' AND post_id = ID) AS NofSeats,
(SELECT MIN(meta_value)
FROM wpps_postmeta
WHERE meta_key='cf_noofseatmax' AND post_id = ID) AS NofSeatsMax,
(SELECT MIN(meta_value)
FROM wpps_postmeta
WHERE meta_key='cf_drivetrain' AND post_id = ID) AS Drivetrain,
(SELECT MIN(meta_value)
FROM wpps_postmeta
WHERE meta_key='cf_gearboxtype' AND post_id = ID) AS GearboxType,
(SELECT MIN(meta_value)
FROM wpps_postmeta
WHERE meta_key='cf_noofgears' AND post_id = ID) AS NoofGears,
(SELECT MIN(meta_value)
FROM wpps_postmeta
WHERE meta_key='cf_noofgears' AND post_id = ID) AS NoofGears,
(SELECT MIN(meta_value)
FROM wpps_postmeta
WHERE meta_key='_price' AND post_id = ID) AS PriceEur,
(SELECT MIN(meta_value)
FROM wpps_postmeta
WHERE meta_key='cf_capacityccm' AND post_id = ID) AS Capacityccm,
(SELECT MIN(meta_value)
FROM wpps_postmeta
WHERE meta_key='cf_length' AND post_id = ID) AS LengthCar
FROM
wpps_posts
WHERE
post_type = 'product' AND post_status = 'publish'
Hi again Madalin
As suspected, the issue comes from the query.
If your MySQL-query based wpDataTable doesn’t work correctly with server-side processing, probably this is happening because wpDataTables server has problems with parsing of the query and building new queries dynamically (rarely happens, but does sometimes). To avoid this please prepare a MySQL view (a stored query), which will return the data that you need, call it e.g. “view1” and then build a wpDataTabled based on a simple query like “SELECT * FROM view1″.
Please note some this when working with the server-side processing feature:
Please note that using sub-queries when creating a view may not work if you have PHP version less than 5.7
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hello, thank you for answer, but don't work, the table is loading and loading after i make the query as you said.
Check Video: https://drive.google.com/file/d/1ZaEriXABcGLXNw-Zu1K52N6YQCdk1KHt/view (SELECT * FROM carstroming1;)
"CREATE VIEW carstroming1 AS
SELECT
(
SELECT name
FROM wpps_terms
LEFT JOIN wpps_term_taxonomy ON (
wpps_term_taxonomy.term_id = wpps_terms.term_id
)
LEFT JOIN wpps_term_relationships ON (
wpps_term_relationships.term_taxonomy_id = wpps_terms.term_id
)
WHERE taxonomy = 'pa_brand' AND wpps_term_relationships.object_id = wpps_posts.ID
LIMIT 1
) AS Brand,
(SELECT MIN(meta_value)
FROM wpps_postmeta
WHERE meta_key='cf_versionmodel' AND post_id = ID) AS Model,
(SELECT MIN(meta_value)
FROM wpps_postmeta
WHERE meta_key='cf_fueltype' AND post_id = ID) AS FuelType,
(
SELECT MIN(meta_value)
FROM wpps_postmeta
WHERE meta_key='_weight' AND post_id = ID) AS Weight,
(SELECT MIN(meta_value)
FROM wpps_postmeta
WHERE meta_key='cf_power' AND post_id = ID) AS Power_hp,
(SELECT MIN(meta_value)
FROM wpps_postmeta
WHERE meta_key='cf_torque' AND post_id = ID) AS Torque,
ROUND((SELECT ((Power_hp / Weight) * 100) AS testp), 2) AS PW,
ROUND((SELECT ((Torque / Weight) * 100) AS test), 2) AS TW,
(SELECT MIN(meta_value)
FROM wpps_postmeta
WHERE meta_key='cf_accelerations' AND post_id = ID) AS Accelerations,
(SELECT MIN(meta_value)
FROM wpps_postmeta
WHERE meta_key='cf_luggagevolumenormal' AND post_id = ID) AS Luggage,
(SELECT MIN(meta_value)
FROM wpps_postmeta
WHERE meta_key='cf_fuelgasconsum' AND post_id = ID) AS FuelConsumption,
'x' AS StartFilters,
(SELECT MIN(meta_value)
FROM wpps_postmeta
WHERE meta_key='cf_co2efficiencyclass' AND post_id = ID) AS Co2consum,
(SELECT MIN(meta_value)
FROM wpps_postmeta
WHERE meta_key='cf_bodytype' AND post_id = ID) AS BodyType,
(SELECT MIN(meta_value)
FROM wpps_postmeta
WHERE meta_key='cf_noofdoors' AND post_id = ID) AS NofDoors,
(SELECT MIN(meta_value)
FROM wpps_postmeta
WHERE meta_key='cf_noofseat' AND post_id = ID) AS NofSeats,
(SELECT MIN(meta_value)
FROM wpps_postmeta
WHERE meta_key='cf_noofseatmax' AND post_id = ID) AS NofSeatsMax,
(SELECT MIN(meta_value)
FROM wpps_postmeta
WHERE meta_key='cf_drivetrain' AND post_id = ID) AS Drivetrain,
(SELECT MIN(meta_value)
FROM wpps_postmeta
WHERE meta_key='cf_gearboxtype' AND post_id = ID) AS GearboxType,
(SELECT MIN(meta_value)
FROM wpps_postmeta
WHERE meta_key='cf_noofgears' AND post_id = ID) AS NoofGears,
(SELECT MIN(meta_value)
FROM wpps_postmeta
WHERE meta_key='_price' AND post_id = ID) AS PriceEur,
(SELECT MIN(meta_value)
FROM wpps_postmeta
WHERE meta_key='cf_capacityccm' AND post_id = ID) AS Capacityccm,
(SELECT MIN(meta_value)
FROM wpps_postmeta
WHERE meta_key='cf_length' AND post_id = ID) AS LengthCar
FROM
wpps_posts
WHERE
post_type = 'product' AND post_status = 'publish'"
Hi again Madalin
Please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Thank you for answer Aleksadar.
Oh, working, but is load over 10 minutes per action, Is there an option to make it load faster?
Hello again Madalin
Loading speed usually depends on the Server performance, and your hosting plan, along with the size of the table. How many rows do you have in that table? How big it is?
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
I have VPS: https://prnt.sc/rl4i5n (pic with config)
The DB have around 1GB, around 100.000 models of cars. https://prnt.sc/rl4ils (pic with dimension)
Yeah, that's a lot of data in one table Madalin.
I don't know if VPS has good enough performance to achieve that, but it sounds like it won't perform well.
We've tested the plugin for millions of rows, and it performs OK when the server, and hosting plan are good. You can connect that database as a Separate DB connection on our sandbox site, and it should perform better.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
When a filter is applied, the resources do not exceed 30% ... so I do not think that is the reason.
On this VPS was an online store with 700,000 products (DB around 4GB) and store working very fine and with max speed.
I send you an email on Aleksandar Vuković
[email protected]
WebCraftic Assets manager, The wp is blank, with a very clasic theme, i dont think that pulgin solve the problem, problem is at wpDataTables.
Gonzales may help by deactivating some scripts, but significantly increasing the performance is not guaranteed with this plugin.
Like I said - your table consists of 2.9 million entries (cells), and to successfully filter it, the plugin needs to go through the entire table, which does take a long time. On localhost it works a lot faster, but it still takes a minute to filter through the first value. After that it works almost instantly.
Please try duplicating your website on our sandbox site, and you'll see a significant increase in performance.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
If it doesn't go instant ... I'll want the money back. I wasted a lot of time with the module trying to make it good.
PS: if i change to checkbox, selectbox, multiselect, the table is broken.
You can try to change a filter in the selectbox, and you see the all table is broken.
Hi again Madalin
For a table with 2.9 million entries, it will never be instant I'm afraid.
Since you opened the ticket in pre-purchase section, I cannot say whether you're still in the "15-day money back guarantee" period, but if you are you can log into our store http://store.tms-plugins.com/ with the credentials you received when you purchased the plugin, navigate to Purchases/wpDataTables, and you'll see "Request Refund" button.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables