I have a name index for past issues of our Journal, with over 350K names. Currently, I work from an MS Access database to generate name-grouped pdf indexes.
I created a table in our database. It does not have the standard Wordpress wp- prefix.
Question: Can I connect directly to this table and only this table to create a searchable index on the website?
Question: Does the table need to have the wp prefix in the table name?
If this is the same database where WordPress resides, all of them would have the same prefix, so you could create a table simply querying it:
SELECT * FROM yourCustomPrefix_table
However, if this is a table located on another database, you would first need to connect that database through wpDataTables settings, as a Separate DB Connection. Then, when creating a table, you would choose that separate DB connection from the dropdown, and use the query box normally to create a table.
You do need to have a prefix in front of the table name, but you don't need to pass the database name?
After going back and looking at it, the table is in the same DB as Wordpress, and I did give it a wp prefix: wp_journal_index_names - so this shouldn't be an issue.
It has almost 400,000 records in it now, and several thousand more when I update it with the last two years worth of Journals.
So a few more quick questions:
Will this size of table pose any issues with wpDataTables? Would it require any special configuration?
Assuming the plugin can handle this, I intend to purchase the plugin for the non-profit organization I'm building this for. So the final question is, can I install this on my dev site to work it out and then install it on my live site under the same license?
I have a name index for past issues of our Journal, with over 350K names. Currently, I work from an MS Access database to generate name-grouped pdf indexes.
I created a table in our database. It does not have the standard Wordpress wp- prefix.
Question: Can I connect directly to this table and only this table to create a searchable index on the website?
Question: Does the table need to have the wp prefix in the table name?
Thanks,
Mark
Hello Mark
Thank you for your interest in wpDataTables.
If this is the same database where WordPress resides, all of them would have the same prefix, so you could create a table simply querying it:
However, if this is a table located on another database, you would first need to connect that database through wpDataTables settings, as a Separate DB Connection. Then, when creating a table, you would choose that separate DB connection from the dropdown, and use the query box normally to create a table.
You do need to have a prefix in front of the table name, but you don't need to pass the database name?
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
Hi, Aleksandar
Thank you for your quick response.
After going back and looking at it, the table is in the same DB as Wordpress, and I did give it a wp prefix: wp_journal_index_names - so this shouldn't be an issue.
It has almost 400,000 records in it now, and several thousand more when I update it with the last two years worth of Journals.
So a few more quick questions:
Will this size of table pose any issues with wpDataTables? Would it require any special configuration?
Assuming the plugin can handle this, I intend to purchase the plugin for the non-profit organization I'm building this for. So the final question is, can I install this on my dev site to work it out and then install it on my live site under the same license?
Thanks,
Mark