Hello everyone, im new in this forum and looking for some help.
I have database that has over 100k records and my website its.. lazy. I think its something with queries and database optimization. So there is my question
It is better to use two or three database for information? or single?
What about queries, its better to recieved data from one connection or make multiply connection with multiply queries?
What about computer, because maybe if I buy new computer it would go alot smoother, and is there some better optimization commands to find data?