0

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

Tom H
  • 44,871
  • 12
  • 81
  • 121
J. Doe
  • 817
  • 6
  • 17
  • 3
    Here is a QA about caching performance [Session VS File VS Memcache](https://stackoverflow.com/questions/1197859/session-vs-file-vs-memcache-for-a-cache-in-php#1197965). Don't forget to look into [Memcache VS Redis](https://stackoverflow.com/questions/10558465/memcached-vs-redis) as well – leninhasda Jan 03 '18 at 17:38
  • 1
    Answer is, it depends – Mark Baker Jan 03 '18 at 17:45
  • depends on what? – J. Doe Jan 04 '18 at 15:29

0 Answers0