2
(click on this box to dismiss)
How CUBRID handle an expensive query on a huge table?
Hi,
How CUBRID handle an expensive query on a huge table or a recursive query?
Will CUBRID partition the big task into some smaller ones and then forward the small task to each processor (I assume the query run on multi processor server) and then merge back?
link
comment (0)
accepted answer
asked last year
![[Level:1]](http://www.cubrid.org/modules/point/icons/default/1.gif "Rank: 1/30, reputation score 13 (50% completed for the next level)"){kind=icon}
arissetyawan13
1
Answer
1
CUBRID is optimized for web services. This means that it is designed to handle small transactions under high load (lots of connections). Because of this, each query execution is single threaded and will be executed across a single core. Expensive queries will be executed as a single task which allows for better concurrency.
![[Level:7]](http://www.cubrid.org/modules/point/icons/default/7.gif "Rank: 7/30, reputation score 491 (91% completed for the next level)"){kind=icon}
ginarrbrik
tagged
asked last year
viewed 762 times