Questions tagged [performance]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
14 views

Eager load entries from another site in a Matrix block

I'm having trouble to get Eager Loading to work with an entries field that can select entries from another site in a multi-site setup. We're using a Matrix content-builder setup. Different kinds of ...
2
votes
3answers
2k views

Slow performance/Long response times

I am running Craft CMS 3 and Commerce 2 on a virtual machine composed of Centos 7, Apache 2.4, PHP 7.2 and MySQL 5.7.22. It seems almost impossible working with the control panel with such huge ...
0
votes
0answers
12 views

Very slow `INSERT` transactions on the resourcepaths table

After a recent update (Craft 3.4.x to 3.5.x) I'm seeing some suspiciously slow response times in relation to INSERT actions on the resourcepaths table. Some in the upwards of a half second for a ...
1
vote
1answer
86 views

How many simultaneous visitors Craft CMS can handle?

I am looking for a CMS as a backbone for front-end work and I like CraftCMS by its interface and structure, so I wonder if CraftCMS is capable for this project. In practice, most of the work will be ...
0
votes
0answers
25 views

Get categories with number of hits (entries, products)

Is there a way to get a list of categories with the number of entries associated with each particular category? I want to output something like this: It would make sense to fetch the number of hits ...
1
vote
1answer
45 views

Performance issues in CP with +60k articles database

We are are working with a large dataset of over 60k articles. The craft control panel has a very hard time loading the entries list tables. Using debug I see that the queries that takes up the longest ...
0
votes
0answers
44 views

Optimize heavy query

I'm trying to show the nutrition information for restaurants using the following snippet {% set nutrition = craft.entries.section('nutrition').Ids() %} {% set ...
1
vote
1answer
46 views

Import / Aggregation DB - with 50 Million Records - Best Practice?

I'm working on my second Craft project ever. (First was an ultra-simple site just to learn the basics.) With this new project I need to accomplish 2 things... (1) - Private - Import/aggregate mass ...
0
votes
1answer
33 views

Performance basics? BlogPost+Comments vs. One ever-expanding Matrix Field?

New to Craft, and unsure how it works under the hood. In terms of overall performance, I'm curious to know which of the following scenarios is the most performant approach in terms of DB queries and ...
0
votes
0answers
33 views

Eager Loading in commerce cart

I'm trying to improve the performance of the craft commerce checkout process. I have some image thumbnails in the cart. Since I can't cache the cart I want to use eager loading for improving the db ...
1
vote
1answer
26 views

Slow Category Loading

I have the following category https://www.ticketstoday.co.uk/theatre which has around 600/700 Entries, this is paginated at 30x Entries a page. Unfortunately, it's loading rather slowly. It's not a ...
0
votes
0answers
201 views

Control panel - Entry indexes very slow

Craft CMS 3.3.15 PHP 7.1.3 MySQL 5.5.42 I have a structure with 360 entries. Right now in the CP it takes 3.5 - 10 seconds to load the first 50. And another 3.5 - 10 seconds for every additional ...
1
vote
1answer
40 views

Is it worth caching product blocks for use on a category page?

So we have a Commerce project that shows lots of products per page/category as per any standard store. Each product block comprises: Product name Product price Brand (via category field) [eager ...
1
vote
1answer
66 views

My month/year archive template code no longer works in 3.2 [closed]

My blog has a date archive page that uses a variation of this code. Here's the code that I've been using: {% set allEntries = craft.entries.section('entries').type(['posts','reviews']).limit(null)....
3
votes
1answer
877 views

Progressive Web App

Is there any way to think about building a site as a Progressive Web App when using Craft CMS? Any steps / plugins that can help build a site as a PWA to enable features like Add to Homescreen, ...
3
votes
1answer
188 views

Craft periodically goes down due to plugin migrations

Our application seems to be crashing periodically, on a seemingly unknown cadence. Sometimes it goes down once every few days, and sometimes (like today, when I'm at the end of my rope) it goes down ...
1
vote
0answers
76 views

What's the most performant way to get reverse related entries within an Element Query?

What's the most performant way to get reverse related entries within an Element Query? Here's a contrived example of this. I have thousands of "book" entries and thousands of "collection" entries. I ...
2
votes
1answer
97 views

Sprout reports timing out on thousands of records

I have sprout reports (twig template) exporting tens of thousands of records. Problem is that its timing out. I appreciate that this is expected and my only likely option is to up the server spec. Is ...
1
vote
0answers
208 views

Error while sending QUERY packet. PID=881 when using cache key

If I do: {% set cacheKey = block.id %} {% cache using key cacheKey if craft.app.config.general.cache %} {% for item in items %} <div class="swiper-slide ais-hits--item" data-id="{{ ...
0
votes
0answers
86 views

Craft on a cPanel hosting with CentOS and CloudLinux – I/O faults?

I'm running Craft on our shared hosting with PHP 7.2. No SSD. Performance is fine, but working in the backend, I often get hickups of several seconds (!), where nothing happens, everything stalls. ...
1
vote
1answer
46 views

Access pages data with fewer queries by creating an object in Twig

I have the goal of querying the database once for page info, and then using it to display information on select pages site wide. For example, I want to link the the contact page with using a url slug ...
4
votes
3answers
4k views

Expected performance benefit of using a non-file CacheMethod (Redis, Memcache)

I'm wondering what kind of performance increase, and in what situations, I might expect from using Redis or Memcache over the default file-based caching. I know template caching always comes from the ...
1
vote
1answer
461 views

How to speed up a single entry page with Eager Loading

This is a single entry page. I have an assets field of imageGallery which allows multiple images to be uploaded but it could also be empty. I want to use the first image at the top of the page (if one ...
2
votes
1answer
1k views

Craft incredibly slow site performance

I am experiencing incredibly slow site performance. This extends to loading the control panel (/dashboard, /login). This only happens when I put the site on to my hosting, locally using MAMP it runs ...
1
vote
0answers
139 views

Eager Loading Entries - Creating a Navigation from a structure

I have a multi-level structure in Craft that is being used for navigation. As part of this I have a few different entry types, but each entry that links to a page has a entry-field of singlePage. At ...
1
vote
1answer
111 views

Correctly using eager loading in Plugin development

I'm trying to get some data with eager loading, which results in more queries than before. Is there another way to tune down the number of queries as low as possible? As you can see i only need the ...
1
vote
1answer
178 views

Improving page performance issue

I'm trying to speed up this page: http://planned2perfection.co.uk/what-we-do Yes it has a lot of images but I think it's TTFB that's the issue here. It's built with Structures which I'm thinking ...
1
vote
1answer
89 views

Entry Count plugin performance / template optimisation

I'm using Ben Croker's Entry Count plugin in my News channel but have noticed a huge performance hit, I know its probably down to how I am loading the entries in to my template so I am looking for ...
1
vote
1answer
357 views

MySQL CPU pegged on specific query

Very similar (almost exact) to this question: Poor performance on midsized site / Queries without index? CPU keeps getting pegged to 100% for MySQL, which makes the admin interface very slow (the ...
3
votes
1answer
112 views

Deleted matrix block means deleted data?

If I delete the Matrix block content (while editing an entry) does the associated is deleted as well or only the block but its data still remains in db?
2
votes
5answers
4k views

How to improve unexpectedly poor Craft performance?

We have a seasonal website which gets very popular around this time of year. This year we ported it from ExpressionEngine to Craft, for all the obvious reasons. We were very surprised to discover that ...
1
vote
1answer
401 views

Compress Craft Control Panel CSS and JS per environment

Is there a way to compress the Craft CSS for a specific environment? Currently there is a setting for Javascript, useCompressedJs, set to true by default. useCompressedJs Tells Craft whether to use ...
2
votes
0answers
135 views

Filtering products by categories and showing number of products related to selected category

I currently have about 420 products and over 100 of categories to choose from for each products, showing the list of categories and filtering it, works fine, and performance is not too bad when it's ...
2
votes
2answers
1k views

Understanding Eager Loading

I am trying to get to grips with Eager Loading. I have the following code: {% for article in entry.relatedArticles %} <div class="c-card // l-card--third"> <a href="{{ article.url }}">...
2
votes
1answer
657 views

Recommended approach for integrating a CDN with a Craft site

I realize there are lots of options out there, but I’d be interested to know what service folks would recommend for integrating a CDN with Craft? It'd also be helpful to know what the general pain ...
2
votes
1answer
502 views

Why is Craft extremely slow when using a shared, external database?

Every now and then I work in developer teams where we all use our local development environment to work on the code, but share the same database on a remote server (like discussed here etc.). Most of ...
0
votes
0answers
112 views

Best way to improve complex query?

This question is related to a previous question I asked: Sort entries in a category via entry field I have a page that is running the same query from the previous question: {% set businesses = craft....
0
votes
1answer
929 views

Laravel Homestead installation nightmare

I'm running Vagrant/Virtual Box on a Windows 10 host. I originally installed Craft on a Vagrant Scotch Box (https://box.scotch.io/). The admin panel was running a little slow so I tried installing in ...
2
votes
1answer
56 views

Can I set the same relation in a field multiple times?

My customer wants a videoplaylist for users. Idealy I'd like to have a assets relation field for the playlist and relate all the videos in said playlist. The problem is if a user wants the same ...
1
vote
0answers
174 views

Craft 3 improvements to relationship querying?

I've been using Craft for a couple of years now and I do love it, however I consistently run into massive performance issues with it. I heavily rely on caching and eager loading - however this doesn't ...
1
vote
1answer
279 views

entries.saveEntry not triggered by ResaveElements task

I've got a plugin that does a thing when an entry is resaved. It works great. However I need it to fire for every single entry to build some data. craft()->on('entries.saveEntry', function(Event $...
3
votes
1answer
532 views

Poor performance on midsized site / Queries without index?

I'm running a mid sized website (couple hundred articles, between 30-50k visits per day) on a Digital Ocean 16GB / 8 Cores web server and I have two questions: Most of the time the website runs ...
0
votes
0answers
79 views

TTBF about 30 seconds

i have a big problem on my site. One for loop requires more than 30 seconds. When i put the loop in a comment, the page loads shortly. So the loop must be the problem. Is there any trick to ...
0
votes
0answers
55 views

25s TTFB for one for-loop [duplicate]

I ask this question a few weeks ago, but could not fix this problem. Now i have minimize my code. i use this loop: {% for program in craft.entries.section('program_point').order('program_number') %} ...
2
votes
1answer
133 views

Plugin loading scheme

This is a fairly generalized question, maybe I completely missed where to learn about this, but I've always been curious about it as it'd help me be a little more aware of what would and would not be ...
1
vote
1answer
856 views

Caching and TTFB with Craft

I've just launched my new site here and I'm playing around with the caching options with Craft. I'm hosting my site with Siteground which gives me access to their Supercacher option, it offers Static ...
0
votes
1answer
335 views

Does Craft CMS support these features? [closed]

I am evaluating different CMS. I need to know if Craft CMS supports these features: Preview function for different devices, screen sizes and screen configurations(portrait/landscape) Is it possible ...
1
vote
0answers
940 views

PHP memory limit, is 1024 MB too much?

I just had some problems with an update exhausting my memory. But I already had the PHP memory limit at 512 MB, and I had to take it up to 1024 MB! I know this is relative but, is this too much? How ...
1
vote
0answers
488 views

Superslow loading of pages in Craft locally

I am having trouble pinpointing the issue but I am struggling with some of my pages taking an absolute age to load. For example; It might be a local MAMP issue, but some pages load fine and I ...
2
votes
0answers
166 views

Neo performance (large page)

I'm using Matrix and Neo to build out quite large, complex entries. On larger pages (70+ blocks each with one-multiple sub-blocks) the performance is taking a bit of a hit taking upwards of 40 seconds ...