The system search is very slow and inefficient. Database
Autore: L. MysonHello, I have a question about the functionality of your search. To be honest, it works very poorly and slowly! I need a search feature to check phone numbers. I have thousands of numbers that make up a blacklist, and I need to set up a search for these numbers. Some of these numbers have corresponding pages, while others don’t.
I created a closed page with a search button that should search the entire site, not just products. However, when I enter a number, for example, +788888888, and press the button, the search takes a very long time. If I place the information on a page, the search shows other pages that don’t contain this number but do have the “+” symbol.
I need an efficient search function in the site’s closed area that can quickly find phone numbers and client information for internal use!
Now, I have enabled the ability to add numbers and other parameters to the database, and when searching, the data appears immediately on the site in a table format, which has 8-10 fields. However, when I add an image, it doesn’t display. I would like to know how I can beautifully display images on the site from the database or even include audio or video when searching by phone number! Additionally, I’m not sure how to make a gallery display images from the database and the table I created. I also don’t know where the system saves these images.
Another question, not directly related to the main request: how can I set up automatic publishing of posts from the website (specifically from the blog) to a Telegram channel? I want new posts to appear immediately in the Telegram channel with a link to the website when they are created.
Hello,
I am sorry about the inconveniences you have encountered.
How large is your website in terms of the number of pages?
If it is currently online, could you provide an URL to take a look at the search page?
Eric
Autore
https://sladostclub.com
Autore
https://sladostclub.com/blacklist.html Number Search
Hello,
I tried to search for both a complete phone number and only the number "78", but in both cases the search only took 5-10 seconds to load.
What kind of loading times you are encountering before the search results are displayed?
Eric
Autore
Yes, it's also somewhere like that, but I didn't think it was so long, it searches the database faster, and it would be better if the search was instant. I deleted many pages because the site is being redesigned and it changes the subject!
Hello,
as the amount of pages is fairly high, I don't think they are unusual loading times, and they are still quite fast.
We will see what can be further optimized.
Eric
Guess it can be optimized.
Search one single site in 10 seconds. Room for improvements.
A project consisting of 200+ pages made with an older X5 version: Search about 3-5 seconds.
acceptable but not impressing compared with Google searching many millions of sites in milliseconds.