Disable lada-cache for certains queries

[f-liva]

lada-cache on Laravel 6 is giving me some problem and sometimes the queries are not invalidated and subsequent queries to the database return inconsistent data.

I would therefore like to understand if it is possible to disable lada-cache for certain queries to the database, here is an example:

MyModel::withoutLadaCache()->updateOrCreate(...);

What do you think?

[spiritix]

L6 is not yet supported. We're working on it. As soon as it's released the mentioned problems should be gone. Do you think it's an actual use case that people might want to disable caching for specific queries? The library already offers an option to disable caching for specific tables.

[f-liva]

Yes, I think the package should allow user to disable it programmately for certain queries, not for certain tables. There are operations I would do without pass trough lada-cache

[spiritix]

I am not sure if this could be implemented like you suggested, since there are many different ways to initiate a query in Laravel (from Models, from Eloquent, from Query Builder, etc.). Possibly we'd end up having something like this:

LadaCache::disable();
MyModel::orderBy('id')->get();
LadaCache::enable();

[f-liva]

Yes this should be pefect!

[grishmadoshi]

Hello, I have similar issue.
For one of the table , there is one counter field which is updated frequently and clearing cache. So is this good idea to disable cache for it as suggested here. Can that have any impact on query where data are actually being read?

[vonec]

any updates on this feature, it be great if we can implement

LadaCache::disable();
MyModel::orderBy('id')->get();
LadaCache::enable();

[spiritix]

Unfortunately I don't have the capacity to implement this at the moment. Contributions are welcome.

[liangguohuan]

This would help，but，it's better to be supported in lada-cache package

// disable cache all
\config(['lada-cache.active' => false]);
// disable specific tables
\config(['lada-cache.exclude-tables' => ['skus']]);
// clear specific model cache
app()->make('lada.handler')->setBuilder((new Sku())->getQuery())->invalidateQuery(Reflector::QUERY_TYPE_UPDATE);

[zgetro]

@spiritix

for such queries don't dependent on model eloquuent methods instad use row queries like
DB::Raw( .... )
raw-expressions

Any of other solutions will not going to CPU optimize as it CPU require to update app instance in memory for request life cycle.
also exclude-tables is not working as expected.