I would suggest inserting your tours as posts (or custom posts) and using a custom reference table with the id matching the post id of the Tour post.
You could use WordPress’s built in meta box functions to be able to edit each Tour in the edit posts page.
You could update your reference table by hooking into the ‘save_post’ action.
There will be a considerable look-up speed improvement if you choose to create this reference table as MYISAM and use fixed column widths along with indexing searchable columns.
With that much data, you could use this option to not only tap in to much of the great WordPress built-in functionality, but ensure speedy look-ups on the extra data.
Related Posts:
- Migrating database / content of non-CMS site to WordPress
- How to solve slow WordPress site caused by attachment_metadata
- Delete all post meta except featured image
- Delete all post meta except featured image Using SQL
- WordPress and MySQL: how to transfer Meta_key and Meta_Value from one post_id to another
- Trouble Migrating all data blog from WordPress.com to WordPress.org
- Migrating from PDO using SQLite to clean new install using MySQL
- Migration: Copying database content to a different server
- “BS_” rows in postmeta table
- How do i get value from wp_postmeta?
- SQL query : Select a thumbnail for a media
- Importing Concrete5 content to WordPress
- Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
- MySQL SELECT increment counter
- Multiple developers / editors working on a site in progress
- How can I make updates to a site, on a development copy, but then move updates back without overriding live site’s evolving database?
- WordPress (MyISAM) database is slow, should I switch to InnoDB?
- Fastest way (least amount of steps) to locally import a remote database using WP-CLI
- Solution for database version control and deployment?
- WordPress Database lost auto increment
- Restoring WordPress posts from database only
- Slow wp_term_relationships query
- How to use “TRUNCATE TABLE” MySQL statement?
- Migrating data between local and development server
- Organizing WP Pages based on old website database
- Using Dynamic Data Pulled from a MySQL Table in a WordPress Page
- What are conventions about the schema of the $table_prefix
- Meta query interfering with orderby relevance
- WooCommerce with thousands of products – site is very slow – optimize db queries? [closed]
- importing data from non-wordpress mysql db
- WooCommerce – Query for ordered products
- How to execute mulitple statement SQL queries using $wpdb->query?
- Query WordPress database by registered date and role
- Tons of Twitter rows in my database
- Set Display Name to first and last name (phpmyadmin SQL Query)
- How to fix unchanged URLs in Database after running serialized search and replace script?
- How do I reset a self-hosted WordPress URL?
- Does WordPress ever need multiple databases?
- Why are no posts showing despite my apparently correct DB restoration?
- Select Multiple meta_value from WP DB; Single Query
- One post carries 30 postmeta values, is this too much?
- Is it possible to split database tables using HyperDB?
- What happens if I overwrite the current wp_options table with a backup from a week ago?
- SQL Error wp_commentmeta – incorrect table definition
- WordPress database error – Error in SQL syntax – I can’t identify any error?
- CRUD operations using WordPress database API
- Migrating WordPress from DreamHost to Azure WordPress Resource via UpdraftPlus “wp_options table does not exist…” error
- How to Mirror WordPress database from Remote server to Local server
- Is MariaDB’s Aria storage engine suitable for WordPress?
- Slow queries constantly getting stuck on WordPress database of ~100,000 posts
- Merging two databases without borking it
- Why does importing copies of the database dump and the document root make WordPress data inconsistent?
- How do I query wp_options for expired transient pairs with MySQL commands?
- WordPress running SQL query to update database from form
- How to fix database error duplicate entry
- Saving zero as meta value
- How do I convert a MySQL database from utf8mb4 to utf8 encoding?
- Query multiple tables at once?
- creating new field on mysql
- Remove empty rows from the database
- Custom WordPress Table wpdb
- Why this query is not showing any result on wordpresss home page?
- Best practice to limit results in get_row()?
- Trouble running $wpdb->query() with last_insert_id
- how to encyrpt DB_PASSWORD in wp-config
- SQL query to set posts in bulk based on the post content
- Changing order of db results when encoding to JSON
- How to transfer from localHost to live but use the already existing database on the server?
- Database migration issues – Error #1046 No database selected
- echo site_url() returns a different value than what is in the database siteurl field
- Compare User meta_value with Product meta_value
- Link multiple user databases together?
- _wp_attachment_metadata is not being added to database when PDF files uploaded
- I wanted to Know that how can I give ingore to 0000-00-00 in my config file
- Set a cron job to delete a specific database table table every midnight
- How to fix Uploaded to this post option to see group of images uploaded to a post?
- How to import products in host instead of database on wordpress?
- I would like some help wth an SQL query to link posts with categories
- Where is the HTML-handler part in the wpdb class?
- next comment id number wordpress
- How to edit posts/pages without making the change live?
- Migrate not successful, DB is broken. How to fix, or at least output static HTML without plugins?
- How can I get $wpdb to show MySQL warnings?
- Merging development site with live site
- The MySQL Connection could not be established., before it was joomla but i have change it into worpress
- How to extract some part of WordPress full source code
- Missing latest posts and options after DB migration via phpMyAdmin
- Check if a database is well installed
- live site do not update after importing sql database
- Restoring .sql backup results in “Error establishing a database connection”
- “MySQL server has gone away” since update to 3.8
- featured image not showing up with mysql_connect
- MySQL Database User: Which Privileges are needed?
- Import Excel (or csv) Table with user-data as subscribers to wordpress
- Print output of Table Creation
- Recommended Post Structure for DB Storage
- Getting an error when trying to migrate to DV server from Grid with Media Temple [closed]
- SQL Query to get post_id from wp_posts and and meta_key(s) from wp_postmeta
- Uploading to WordPress Database
- Have WordPress Use a Different Database for users