View Single Post

  #2 (permalink)  
Old 04-17-2007
Hans H
 
Posts: n/a
Default Re: Mysql performance for online applications


"adzir" <muadzir@yahoo.com> schreef in bericht
news:1176523222.383015.210680@o5g2000hsb.googlegro ups.com...
> Hi,
>
> Just asking out of my curiosity. Which of these can hamper performance
> of my online applications?
>
> Having multiple small databases open concurrently or huge size of one
> single database? What happen for its long term run?
>


That is a tricky one. What is huge?
If you have lots of queries, that will join those small tables, you will pay
a perfomance penalty.
Having one huge database might get you to the limits of the OS.


Reply With Quote