Why is the database search so slow?

asked 2015-02-05 05:01:12 -0600

Chesnaught
21 ●3 ●2 ●5

updated 2015-02-10 03:23:20 -0600

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?

edit retag flag offensive close merge delete

Comments

Which database engine are you using?

Evgeny ( 2015-02-13 12:14:22 -0600 )edit

We're using MySQL

Chesnaught ( 2015-03-12 08:16:57 -0600 )edit

add a comment

1 Answer

Sort by » oldest newest most voted

answered 2015-02-18 14:40:37 -0600

Sindbad

23 ●3 ●2 ●8

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.

edit flag offensive delete link

add a comment

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Question Tools

1 follower

Stats

Asked: 2015-02-05 05:01:12 -0600

Seen: 334 times

Last updated: Feb 18 '15

Why is the database search so slow? edit