|
 Search optimization.
 July 14th 2025
(language: English // Russian)
I have optimized the database search system: now it works much faster and more economically.
Previously, the program downloaded all records from the database (including unnecessary ones), and word search was performed directly in a separate script. This slowed down the work, especially with a large amount of data.
Now everything is different: the program immediately sends a query to the database - to find only those records where the desired word occurs in the title or description. The database itself quickly finds matches (especially with indexes) and returns only relevant results.
|
Social
Older
