[kokosan]

Indeed the weaken point is the database. I have many sites but only this site requires more space for database. Thank you for your suggestions. I will think about hosting when I get things done.

[kokosan]

Here is the search1 concept, which mainly targets contents https://drive.google.com/file/d/1rKcCMavShfyAYgDo6fDl3f1E7_ZW2600/view?usp=sharing

[kokosan]

Here a video in case you may want to have a look. https://drive.google.com/file/d/1mvc3oamNC0a2yA1FUCa_e7LTO3pNfU3o/view?usp=sharing

[kokosan]

Let me explain about the concept of my project. They are two main searches:

Search1: As you can see the search on the home page, I want every word that maches a keyword to display. They are books. So, each post represents a book page. Category and tag are used for filter (category is the name for a book and tag is the name for the book types). Custom field is used to mark page numbers. In this case, the search doesn’t target category, tag and custom field, but mainly target contents and titles. But the titles don’t contain many texts like the contents. So, the search mainly targets the contents because they contain the most texts.

Search2: Mainly target custom field (I have some texts in the custom field to search for, it’s quite long texts), maybe target category, tag and other taxomomy terms as well.

Note: All the concept is to make sure that people get all the related search results from all the page from all the books. If what you suggest affects the search result concept, never mind I would prefer to go with it and choose a suitable hosting plan. But at least optimize what can be done if possible.

[kokosan]

I forget to mention…Actually, the amount that has updated contents is 35,651posts. So still 26,729 empty content posts need to be updated (have only titles but not yet content). If all the contents are updated to the total amount, it would be more than 2.5 GiB, I think.

[kokosan]

Ok now

[kokosan]

how about query posts using order parameter ASC order (‘order’ => ‘ASC’), which is a normal function? https://developer.wordpress.org/reference/classes/wp_query/#order-orderby-parameters

Sorry I don’t have much knowleage about WP.

[kokosan]

I still don’t understand why in the post editor it’s not in the correct order while custom query and other filter plugins do. I plan and create posts in order, per page with per page number. But it’s not in correct order in post editor.

[kokosan]

Ok, will try your code and take sometime to check and confirm. But let me add something, in Essentail Grid I also choose order by date, not by ID, But still it shows correctly (even not order by id) https://drive.google.com/file/d/1PN3MNZRIOeHurR3zLz3d4Qu00ts4xDAc/view?usp=sharing

[kokosan]

I also try this plugin Essential Grid, which is one of the most popular that has filter and ASC order like your plugin. It also has shortcode to display posts like your plugin. With this plugin, it displays posts in ASC order correctly. After 9, it’s 10, 11, etc. You can check this in the home page, just hover your mouse on the grids.

[kokosan]

I create posts in order by importing CSV. Each post is arranged in order on the Excel row. Every post has page numner, which indicates the order correctly.

[kokosan]

I use WOLF bulk editor. In its dashboard, it dispplays in an ASC order correctly https://drive.google.com/file/d/1hw1zxuYqnwGlQSTolYnAJ7GZFNtyr-2W/view?usp=sharing

[kokosan]

Strange to me, I use custom query to display post with ‘order’ => ‘ASC’ and it displays correctly. After 9 and it’s 10 not 11. If the creation dates are incorrectly set on the actual posts, the order in the custom query woudl not incorrect also.

[kokosan]

For example after page number 9 (post 9) it should be 10. but 11, etc. If you want to check the search instance, it’s the first one.

[kokosan]

You cannot access this content.

[Author]

Posts