Why is the database search so slow?
We have a database of over 30.000 questions, and the search is very slow. The version in use is 0.7.49 Do you have any suggestions to speed up things?
We have a database of over 30.000 questions, and the search is very slow. The version in use is 0.7.49 Do you have any suggestions to speed up things?
YAAAH , database will be very slow if you use sqlite3 database and database file size will be large، Askbot works fine with PostgreSQL database because Postgres is extremely capable of handling many tasks very efficiently. Support for concurrency is achieved without read locks thanks to the implementation of Multiversion Concurrency Control (MVCC), which also ensures the ACID compliance.
Please start posting anonymously - your entry will be published after you log in or create a new account.
Asked: 2015-02-05 05:01:12 -0600
Seen: 334 times
Last updated: Feb 18 '15
Tips On Choosing A Ghostwriter For Seo Purposes
9 Most Effective Job Search Websites In 2022
How to Select The Right Seo Company In 2012
How to set search box under 'Tags' tab to search by questions like on main page, not by tag name ?
How does the search system work?
Trial And Error + Persistence = Successful Marketing
Which database engine are you using?
We're using MySQL