'how to cache external url data in wordpress
I am using Google Sheets to display data in my WordPress table. I found this code to call single cell data as simple text, but the problem is it's requesting multiple times to google sheet URL so the page size and load time are too long
How can we cache the google sheet URL for 2 hours so the page can make lower requests?
<table style="border-collapse: collapse; width: 100%;">
<tbody>
<tr>
<td style="width: 50%;">[tt] [gdoc key="https://docs.google.com/spreadsheets/d/hgfgcyghbjhbjh/edit?usp=sharing" query="select D limit 1 offset 1" class="no-datatables"] [/tt]</td>
<td style="width: 50%;">[tt] [gdoc key="https://docs.google.com/spreadsheets/d/hgfgcyghbjhbjh/edit?usp=sharing" query="select A limit 1 offset 1" class="no-datatables" ] [/tt]</td>
</tr>
<tr>
<td style="width: 50%;">[tt] [gdoc key="https://docs.google.com/spreadsheets/d/hgfgcyghbjhbjh/edit?usp=sharing" query="select D limit 1 offset 2" class="no-datatables" ] [/tt]</td>
<td style="width: 50%;">[tt] [gdoc key="https://docs.google.com/spreadsheets/d/hgfgcyghbjhbjh/edit?usp=sharing" query="select A limit 1 offset 2" class="no-datatables" ] [/tt]</td>
</tr>
<tr>
<td style="width: 50%;">[tt] [gdoc key="https://docs.google.com/spreadsheets/d/hgfgcyghbjhbjh/edit?usp=sharing" query="select D limit 1 offset 3" class="no-datatables" ] [/tt]</td>
<td style="width: 50%;">[tt] [gdoc key="https://docs.google.com/spreadsheets/d/hgfgcyghbjhbjh/edit?usp=sharing" query="select A limit 1 offset 3" class="no-datatables" ] [/tt]</td>
</tr>
<tr>
<td style="width: 50%;">[tt] [gdoc key="https://docs.google.com/spreadsheets/d/hgfgcyghbjhbjh/edit?usp=sharing" query="select D limit 1 offset 4" class="no-datatables"] [/tt]</td>
<td style="width: 50%;">[tt] [gdoc key="https://docs.google.com/spreadsheets/d/hgfgcyghbjhbjh/edit?usp=sharing" query="select A limit 1 offset 4" class="no-datatables" ] [/tt]</td>
</tr>
<tr>
<td style="width: 50%;">[tt] [gdoc key="https://docs.google.com/spreadsheets/d/hgfgcyghbjhbjh/edit?usp=sharing" query="select D limit 1 offset 5" class="no-datatables"] [/tt]</td>
<td style="width: 50%;">[tt] [gdoc key="https://docs.google.com/spreadsheets/d/hgfgcyghbjhbjh/edit?usp=sharing" query="select A limit 1 offset 5" class="no-datatables" ] [/tt]</td>
</tr>
</tbody>
</table>
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|