First time here? Check out the FAQ!
1

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?

Chesnaught's avatar
21
Chesnaught
asked 2015-02-05 05:01:12 -0500, updated 2015-02-10 03:23:20 -0500
edit flag offensive 0 remove flag close merge delete

Comments

Which database engine are you using?

Evgeny's avatar Evgeny (2015-02-13 12:14:22 -0500) edit

We're using MySQL

Chesnaught's avatar Chesnaught (2015-03-12 08:16:57 -0500) edit
add a comment see more comments

1 Answer

0

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.

Sindbad's avatar
23
Sindbad
answered 2015-02-18 14:40:37 -0500
edit flag offensive 0 remove flag delete link

Comments

add a comment see more comments