Stack Overflow
Stack Overflow

Questions tagged [database-caching]

Questions regarding using database caching layer to increase performance

25 questions
9
votes
3 answers

How do I know if the prepared statements are cached?

I am using Hikari with SQL Server 2016 and sqljdbc4-2.0.jar in the tomcat lib folder. My configuration for db resource is as follows:
would_like_to_be_anon
  • 1,639
  • 2
  • 29
  • 47
5
votes
1 answer

SQL Query minimizing/caching in a C++ application

I'm writing a project in C++/Qt and it is able to connect to any type of SQL database supported by the QtSQL (http://doc.qt.nokia.com/latest/qtsql.html). This includes local servers and external ones. However, when the database in question is…
Aktau
  • 1,847
  • 21
  • 30
5
votes
1 answer

database caching with codeigniter problems

I've just built a site using codeigniter and mysql. It works great, but I want to turn the database caching on. I figured I would just do it globally rather than caching each select statement manually. in my database config file, I set 'cache_on' =…
Bill
  • 5,478
  • 17
  • 62
  • 95
4
votes
2 answers

Best practice for a local database cache?

I am working on an application that depends on a MySQL database for parts of the content. In some cases, the application will run in an environment with limited internet connectivity (UMTS), in particular suffering from high latencies. A user of the…
Ton van den Heuvel
  • 10,157
  • 6
  • 43
  • 82
3
votes
3 answers

Error database_closed when using flutter's sqflite

I try to use sqflite to save some data like my class Movie but when i try to insert or query on the database, see this message: [ERROR:flutter/lib/ui/ui_dart_state.cc(166)] Unhandled Exception: DatabaseException(error database_closed) my MovieBloc…
Mohammad Shamsi
  • 521
  • 4
  • 11
3
votes
1 answer

Laravel 4 Cache::remember is never returning a response with a given ID

I am using Laravel 4 in conjunction with the a PHP Shopify connector. I am trying to limit the calls made to retrieve Shopify products by caching the particular product pages when they are first needed. I made the following simple route in Laravel…
Aaron Frey
  • 61
  • 7
2
votes
1 answer

EnterpriseLibrary Caching in Load Balance

Can I Use Microsoft Enterprise Library Caching in Load Balance servers?, My case is I have a web service located in 2 load balance servers, and I use Database Cache "backingStores" with configuration like below
Tarek El-Mallah
  • 4,015
  • 1
  • 31
  • 46
2
votes
0 answers

Why does looking up JSONB fields increase query time by 62x in Postgres?

I'm running a simple query that retrieves data from a single table. If I only look up non-JSON fields that are in the table the query takes 16 ms. If I include fields that references fields in JSONB data then it increases by 62x. If I look up two…
kashiraja
  • 740
  • 11
  • 24
2
votes
0 answers

Codeigniter db cache conflict with browser cache

I'm using db cache in my codeigniter project and when I uploaded that application to the server there is a little conflict between db cache that I use and store on the server and browser cache that I use with htaccess file. What's exactly the…
SakuragiRokurota
  • 185
  • 1
  • 3
  • 12
2
votes
1 answer

Codeigniter caching web-page vs database. What is the Deference?

Now I just starting using codeigniter as framework. I have a lot of data will be saved on database. I read more on caching system of codeigniter. And I found that there is two types of caching on it DATABASE CACHING & WEB PAGE CACHING. My Question…
Momen Noor
  • 23
  • 5
2
votes
1 answer

net.sf.ehcache.ObjectExistsException: The Default Cache has already been configured

I am using Spring (4.2.6.RELEASE) with Hibernate(5.1.0.Final). Hibernate properties defined as a bean in spring.xml. And i added ehcache for second-level caching library. I am getting error net.sf.ehcache.ObjectExistsException: The Default Cache…
luckystones
  • 301
  • 4
  • 14
2
votes
3 answers

How to do DB memcaching in Django with derived data?

NOTE: This is a detailed question asking how best to implement and manage Database caching in my web-application with memcached. This question uses Python/Django to illustrate the data-models and usage, but the language is not really that relevant.…
Saqib Ali
  • 11,931
  • 41
  • 133
  • 272
2
votes
1 answer

Caching expensive SQL query in memory or in the database?

Let me start by describing the scenario. I have an MVC 3 application with SQL Server 2008. In one of the pages we display a list of Products that is returned from the database and is UNIQUE per logged in user. The SQL query (actually a VIEW) used to…
AndreCruz
  • 653
  • 4
  • 12
1
vote
3 answers

What are some database caching options for .Net?

I see on the web there are a lot of questions about caching ASP.Net, but not a lot of discussion on caching options for a Smart Client Application and their databases. What are the data caching options that are available for Smart Client Application…
Tom Anderson
  • 10,807
  • 3
  • 46
  • 63
1
vote
0 answers

codeigniter database cache doesn't work

I just want to know because I have an issue with codeigniter database caching. I tried to enable the cache thru the database.php file $db['default']['cache_on'] = TRUE; $db['default']['cachedir'] = "application/cache"; The thing is, it…
user3041604
  • 11
  • 1
1
2