2 million data cache?

[eskoctr]

What's your question ?

How can I cache a mysql table with 2 million rows?

References (optional)

No response

Do you have anything more you want to share? (optional)

No response

[github-actions]

Hello curious contributor !
Since it seems to be your first contribution, make sure that you've been:

• Reading and searching out our WIKI
• Reading and agreed with our Code Of Conduct
• Reading and understood our Coding Guideline
• Reading our README
  If everything looks unclear to you, tell us what 😄
  The Phpfastcache Team

[Geolim4]

How can I cache a mysql table with 2 million rows?

Short answer: Don't.

Long answer: If caching 2 millions rows is the solution to some overload/timeout issue then you probably asking yourself the wrong question.

[eskoctr]

Thanks. So, is partitioned storage possible? I'm trying to do something special. For example, there is a 200mb document, but I want to separate it into 3mb documents and combine them in the query. Is it possible?

[Geolim4]

You don't need a cache, you either need a CDN or a document storage (Solr, AWS, or NoDB storage).

[Geolim4]

Hello @eskoctr ,

I’m closing this issue for now because of (inactivity / outdated code / …).

You can always reopen it though! :)
Please (update the issue / add comment / clarify …).

Regards,
Georges.L