Which is Better? Cache on a Disk File or Cache in a Temporary Table in MySQL?

If indexes themselves being a bottleneck due to frequent writes, no cache will solve the problem, slow database will make whole system slow. You have to rebuild your database structure in this case If it's going to be insufficient key-cache for database server, it's matter of proper tuning or hardware upgrading Or zillions other certain recipes to solve certain problems Honestly, all that "which is faster" crap has not a slightest relation to performance problems The only question can be accepted is "I have certain problem with something Here are benchmarks and investigation results What's the best solution? Otherwise no answer will do help.

Especially one from usual Stackoverflow user who just heard of some technology but never used it in real. And always tends to cure a symptom, not disease.

It's impossible to answer such vague (and possible out-of-nowhere) question. The answer depends on circumstances (if any) which made you to put up such a problem. For example, Conditional Get HTTP caching will do the job without wasting any space on the server in any form (and good site have to implement it anyway).

If you're taking database as possible solution, why not to use it in proper way? By proper indexing queries and using built in query cache? If indexes themselves being a bottleneck due to frequent writes, no cache will solve the problem, slow database will make whole system slow.

You have to rebuild your database structure in this case. If it's going to be insufficient key-cache for database server, it's matter of proper tuning or hardware upgrading. Or zillions other certain recipes to solve certain problems.

Honestly, all that "which is faster" crap has not a slightest relation to performance problems. The only question can be accepted is "I have certain problem with something. Here are benchmarks and investigation results.

What's the best solution? " Otherwise no answer will do help. Especially one from usual Stackoverflow user who just heard of some technology but never used it in real.

And always tends to cure a symptom, not disease.

Database because it will resolve any concurrency problem, which the file doesn't provide you with.

Sorry- but your question is still quite vague in terms of what you mean by "performance". Temporary tables can only be looked at once, but if you cache the information, you can look at it frequently.

I am under the impression that he is not talking about temporary tables – Neal Mar 22 at 17:48 Possibly, but he did use the word "temporary table" in the actual title of the question and specified the question is self-explained. :) – Duniyadnd Mar 22 at 18:19.

Then I suggest MySQL. It will definitely be worth getting it set up. Also, pure disk caching can lead to issues if you don't delete the file cache and it fills up your alloted space.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.