I've a php project that manages courses that contains mostly text. It's separated in sections and lections and requires many SQL queries to build the site.
Is it a big performance increase if I cache the SQL queries in text files and load them from there?
The texts won't change for a long time while other small attributes change continuously.
As an example: Is it faster to read 1000 Chars from a text file than to read 1000 Chars from a SQL-Column?
Thanks