Optimizing Table Load Speed

D

Dennis Koch•2/20/24, 6:59 AM

Both 1s and 4s are bad performance for both tools. Do you have Debugging stuff enabled? What machine is this running on?

J

Jr.PikongOP•2/20/24, 7:43 AM

no, I don't use debugging, because this is already in production, I use Kubernetes and apache and image : php:8.2-apache

S

S. Mert ÖZTÜRK•2/20/24, 7:57 AM

did you try php artisan icons:cache

J

Jr.PikongOP•2/20/24, 7:57 AM

@S. Mert ÖZTÜRK
Things I've already done:
Ran php artisan optimize:clear
Ran php artisan config:cache
Ran php artisan view:cache
Ran php artisan route:cache
Ran php artisan icons:cache

S

S. Mert ÖZTÜRK•2/20/24, 7:58 AM

oh sorry i didn't see it, my mistake. Which is your using database

J

Jr.PikongOP•2/20/24, 8:03 AM

I Use mysql : db.t3.medium Single-AZ instance (AWS )

J

Jr.PikongOP•2/20/24, 8:04 AM

this is my code :

message.txt10.05KB

S

S. Mert ÖZTÜRK•2/20/24, 8:08 AM

can u try to remove declare and simplify your table. It's just a guess

S

S. Mert ÖZTÜRK•2/20/24, 8:09 AM

I've never tried it before, but all that formatting and other stuff might be delaying loading. In simpler terms, we can at least try and measure the difference.

J

Jr.PikongOP•2/20/24, 8:11 AM

simplifying the table I think it doesn't have much of an impact, because in other resources with the same amount of data with simpler table columns, the results are the same

J

Jr.PikongOP•2/20/24, 8:11 AM

but for declare I can try

S

S. Mert ÖZTÜRK•2/20/24, 8:12 AM

So may we have problem with server setup, do you have any chance to try on diffrent server? or local.

J

Jr.PikongOP•2/20/24, 8:14 AM

declare make an impact approximately 1s

J

Jr.PikongOP•2/20/24, 8:14 AM

prod and local same a result .

S

S. Mert ÖZTÜRK•2/20/24, 8:15 AM

I only have one idea left: Install a new Laravel and filament and try the same table without installing anything else.

S

S. Mert ÖZTÜRK•2/20/24, 8:16 AM

Maybe your installed packages crush or impact some performance

SS. Mert ÖZTÜRK Maybe your installed packages crush or impact some performance

J

Jr.PikongOP•2/20/24, 8:21 AM

Thank you for the advice

J

Jr.PikongOP•2/20/24, 8:22 AM

while waiting for suggestions from others

SS. Mert ÖZTÜRK Maybe your installed packages crush or impact some performance

J

Jr.PikongOP•2/20/24, 8:23 AM

because if I look at the packages I use, there aren't many

"requires": {
"php": "^8.2",
"ariaieboy/filament-currency": "^1.2",
"aymanalhattami/filament-page-with-sidebar": "^2.2",
"barryvdh/laravel-dompdf": "^2.0",
"bezhansalleh/filament-shield": "^3.2",
"calebporzio/sushi": "^2.5",
"filament/filament": "^3.2",
"flowframe/laravel-trend": "^0.1.5",
"guzzlehttp/guzzle": "^7.2",
"laravel/framework": "^10.10",
"laravel/sanctum": "^3.2",
"laravel/tinker": "^2.8",
"league/flysystem-aws-s3-v3": "^3.0",
"league/flysystem-path-prefixing": "^3.0",
"league/flysystem-read-only": "^3.0",
"parallax/filament-syntax-entry": "^1.0"
},

S

S. Mert ÖZTÜRK•2/20/24, 8:25 AM

yes not many but maybe some packages impact on performance. And we dont know which it is, if it is.

S

S. Mert ÖZTÜRK•2/20/24, 8:26 AM

Last thing for try, Can you share your env file, by hiding important infos

S

S. Mert ÖZTÜRK•2/20/24, 8:28 AM

and how do you power up your application, with php artisan serve or serve direclty from public?

J

Jr.PikongOP•2/20/24, 8:29 AM

this my .env

APP_NAME="INTERNAL-DASHBOARD"
APP_ENV=production
APP_KEY=base64:nQixtHIGs7ZPLHG24NGMHky
APP_DEBUG=false
APP_URL=https://xxx.com
ASSET_URL=https://xxx.com

LOG_CHANNEL=stdout
LOG_DEPRECATIONS_CHANNEL=null
LOG_LEVEL=debug

DB_CONNECTION=mysql
DB_HOST=xxxx
DB_PORT=3306
DB_DATABASE=xxx
DB_USERNAME=xxx
DB_PASSWORD=xxxx

BROADCAST_DRIVER=redis
CACHE_DRIVER=redis
FILESYSTEM_DISK=s3
QUEUE_CONNECTION=redis
SESSION_DRIVER=redis
SESSION_LIFETIME=120

MEMCACHED_HOST=127.0.0.1

REDIS_HOST=xxx
REDIS_PASSWORD=xx
REDIS_PORT=6379
REDIS_DB=h2hNewDBWeb

MAIL_MAILER=smtp
MAIL_HOST=smtp.gmail.com
MAIL_PORT=465
MAIL_USERNAME=xxx
MAIL_PASSWORD=xx
MAIL_ENCRYPTION=ssl
MAIL_FROM_ADDRESS=developer.smtel@gmail.com
MAIL_FROM_NAME="${APP_NAME}"

AWS_ACCESS_KEY_ID=xxxx
AWS_SECRET_ACCESS_KEY=xxx
AWS_DEFAULT_REGION=xxx
AWS_BUCKET=xxx

APP_NAME="INTERNAL-DASHBOARD"
APP_ENV=production
APP_KEY=base64:nQixtHIGs7ZPLHG24NGMHky
APP_DEBUG=false
APP_URL=https://xxx.com
ASSET_URL=https://xxx.com

LOG_CHANNEL=stdout
LOG_DEPRECATIONS_CHANNEL=null
LOG_LEVEL=debug

DB_CONNECTION=mysql
DB_HOST=xxxx
DB_PORT=3306
DB_DATABASE=xxx
DB_USERNAME=xxx
DB_PASSWORD=xxxx

BROADCAST_DRIVER=redis
CACHE_DRIVER=redis
FILESYSTEM_DISK=s3
QUEUE_CONNECTION=redis
SESSION_DRIVER=redis
SESSION_LIFETIME=120

MEMCACHED_HOST=127.0.0.1

REDIS_HOST=xxx
REDIS_PASSWORD=xx
REDIS_PORT=6379
REDIS_DB=h2hNewDBWeb

MAIL_MAILER=smtp
MAIL_HOST=smtp.gmail.com
MAIL_PORT=465
MAIL_USERNAME=xxx
MAIL_PASSWORD=xx
MAIL_ENCRYPTION=ssl
MAIL_FROM_ADDRESS=developer.smtel@gmail.com
MAIL_FROM_NAME="${APP_NAME}"

AWS_ACCESS_KEY_ID=xxxx
AWS_SECRET_ACCESS_KEY=xxx
AWS_DEFAULT_REGION=xxx
AWS_BUCKET=xxx

APP_NAME="INTERNAL-DASHBOARD"
APP_ENV=production
APP_KEY=base64:nQixtHIGs7ZPLHG24NGMHky
APP_DEBUG=false
APP_URL=https://xxx.com
ASSET_URL=https://xxx.com

LOG_CHANNEL=stdout
LOG_DEPRECATIONS_CHANNEL=null
LOG_LEVEL=debug

DB_CONNECTION=mysql
DB_HOST=xxxx
DB_PORT=3306
DB_DATABASE=xxx
DB_USERNAME=xxx
DB_PASSWORD=xxxx

BROADCAST_DRIVER=redis
CACHE_DRIVER=redis
FILESYSTEM_DISK=s3
QUEUE_CONNECTION=redis
SESSION_DRIVER=redis
SESSION_LIFETIME=120

MEMCACHED_HOST=127.0.0.1

REDIS_HOST=xxx
REDIS_PASSWORD=xx
REDIS_PORT=6379
REDIS_DB=h2hNewDBWeb

MAIL_MAILER=smtp
MAIL_HOST=smtp.gmail.com
MAIL_PORT=465
MAIL_USERNAME=xxx
MAIL_PASSWORD=xx
MAIL_ENCRYPTION=ssl
MAIL_FROM_ADDRESS=developer.smtel@gmail.com
MAIL_FROM_NAME="${APP_NAME}"

AWS_ACCESS_KEY_ID=xxxx
AWS_SECRET_ACCESS_KEY=xxx
AWS_DEFAULT_REGION=xxx
AWS_BUCKET=xxx

APP_NAME="INTERNAL-DASHBOARD"
APP_ENV=production
APP_KEY=base64:nQixtHIGs7ZPLHG24NGMHky
APP_DEBUG=false
APP_URL=https://xxx.com
ASSET_URL=https://xxx.com

LOG_CHANNEL=stdout
LOG_DEPRECATIONS_CHANNEL=null
LOG_LEVEL=debug

DB_CONNECTION=mysql
DB_HOST=xxxx
DB_PORT=3306
DB_DATABASE=xxx
DB_USERNAME=xxx
DB_PASSWORD=xxxx

BROADCAST_DRIVER=redis
CACHE_DRIVER=redis
FILESYSTEM_DISK=s3
QUEUE_CONNECTION=redis
SESSION_DRIVER=redis
SESSION_LIFETIME=120

MEMCACHED_HOST=127.0.0.1

REDIS_HOST=xxx
REDIS_PASSWORD=xx
REDIS_PORT=6379
REDIS_DB=h2hNewDBWeb

MAIL_MAILER=smtp
MAIL_HOST=smtp.gmail.com
MAIL_PORT=465
MAIL_USERNAME=xxx
MAIL_PASSWORD=xx
MAIL_ENCRYPTION=ssl
MAIL_FROM_ADDRESS=developer.smtel@gmail.com
MAIL_FROM_NAME="${APP_NAME}"

AWS_ACCESS_KEY_ID=xxxx
AWS_SECRET_ACCESS_KEY=xxx
AWS_DEFAULT_REGION=xxx
AWS_BUCKET=xxx

SS. Mert ÖZTÜRK and how do you power up your application, with php artisan serve or serve direcl...

J

Jr.PikongOP•2/20/24, 8:30 AM

I use kubernetes and Docker

FROM php:8.2-apache
#
RUN set -eux \
    && apt-get update \
    && apt-get install -y libzip-dev zlib1g-dev \
    && docker-php-ext-install zip
#
ENV DEBIAN_FRONTEND noninteractive
ENV TZ=Asia/Jakarta

RUN ln -snf /usr/share/zoneinfo/$TZ /etc/localtime && echo $TZ > /etc/timezone

RUN apt-get update --fix-missing
RUN apt-get install -y curl
#COPY src/supervisord.conf /etc/supervisor/conf.d/supervisord.conf
RUN apt-get install -y build-essential libssl-dev zlib1g-dev libpng-dev libjpeg-dev libfreetype6-dev libicu-dev

RUN a2enmod rewrite headers
#RUN docker-php-ext-configure gd --with-freetype-dir=/usr/include/ --with-jpeg-dir=/usr/include/ \
#    && docker-php-ext-install gd

RUN pecl install -o -f redis \
&&  rm -rf /tmp/pear \
&&  docker-php-ext-enable redis

RUN docker-php-ext-install pdo_mysql gd intl

COPY src/000-default.conf /etc/apache2/sites-available/000-default.conf

WORKDIR /var/www/html
COPY src/ /var/www/html/

RUN apt-get -y autoremove
RUN apt-get -y clean
RUN docker-php-ext-install pcntl

RUN curl -sS https://getcomposer.org/installer | php -- --install-dir=/usr/local/bin --filename=composer
RUN composer install --prefer-dist --no-dev -o

RUN php artisan optimize:clear
RUN php artisan config:cache
RUN php artisan view:cache
RUN php artisan route:cache
RUN php artisan icons:cache


RUN chgrp -R www-data storage bootstrap/cache
RUN chmod -R ug+rwx storage bootstrap/cache
RUN chown -R www-data: /var/www/html

# USER www-data

EXPOSE 80
CMD ["apache2-foreground"]

FROM php:8.2-apache
#
RUN set -eux \
    && apt-get update \
    && apt-get install -y libzip-dev zlib1g-dev \
    && docker-php-ext-install zip
#
ENV DEBIAN_FRONTEND noninteractive
ENV TZ=Asia/Jakarta

RUN ln -snf /usr/share/zoneinfo/$TZ /etc/localtime && echo $TZ > /etc/timezone

RUN apt-get update --fix-missing
RUN apt-get install -y curl
#COPY src/supervisord.conf /etc/supervisor/conf.d/supervisord.conf
RUN apt-get install -y build-essential libssl-dev zlib1g-dev libpng-dev libjpeg-dev libfreetype6-dev libicu-dev

RUN a2enmod rewrite headers
#RUN docker-php-ext-configure gd --with-freetype-dir=/usr/include/ --with-jpeg-dir=/usr/include/ \
#    && docker-php-ext-install gd

RUN pecl install -o -f redis \
&&  rm -rf /tmp/pear \
&&  docker-php-ext-enable redis

RUN docker-php-ext-install pdo_mysql gd intl

COPY src/000-default.conf /etc/apache2/sites-available/000-default.conf

WORKDIR /var/www/html
COPY src/ /var/www/html/

RUN apt-get -y autoremove
RUN apt-get -y clean
RUN docker-php-ext-install pcntl

RUN curl -sS https://getcomposer.org/installer | php -- --install-dir=/usr/local/bin --filename=composer
RUN composer install --prefer-dist --no-dev -o

RUN php artisan optimize:clear
RUN php artisan config:cache
RUN php artisan view:cache
RUN php artisan route:cache
RUN php artisan icons:cache


RUN chgrp -R www-data storage bootstrap/cache
RUN chmod -R ug+rwx storage bootstrap/cache
RUN chown -R www-data: /var/www/html

# USER www-data

EXPOSE 80
CMD ["apache2-foreground"]

FROM php:8.2-apache
#
RUN set -eux \
    && apt-get update \
    && apt-get install -y libzip-dev zlib1g-dev \
    && docker-php-ext-install zip
#
ENV DEBIAN_FRONTEND noninteractive
ENV TZ=Asia/Jakarta

RUN ln -snf /usr/share/zoneinfo/$TZ /etc/localtime && echo $TZ > /etc/timezone

RUN apt-get update --fix-missing
RUN apt-get install -y curl
#COPY src/supervisord.conf /etc/supervisor/conf.d/supervisord.conf
RUN apt-get install -y build-essential libssl-dev zlib1g-dev libpng-dev libjpeg-dev libfreetype6-dev libicu-dev

RUN a2enmod rewrite headers
#RUN docker-php-ext-configure gd --with-freetype-dir=/usr/include/ --with-jpeg-dir=/usr/include/ \
#    && docker-php-ext-install gd

RUN pecl install -o -f redis \
&&  rm -rf /tmp/pear \
&&  docker-php-ext-enable redis

RUN docker-php-ext-install pdo_mysql gd intl

COPY src/000-default.conf /etc/apache2/sites-available/000-default.conf

WORKDIR /var/www/html
COPY src/ /var/www/html/

RUN apt-get -y autoremove
RUN apt-get -y clean
RUN docker-php-ext-install pcntl

RUN curl -sS https://getcomposer.org/installer | php -- --install-dir=/usr/local/bin --filename=composer
RUN composer install --prefer-dist --no-dev -o

RUN php artisan optimize:clear
RUN php artisan config:cache
RUN php artisan view:cache
RUN php artisan route:cache
RUN php artisan icons:cache


RUN chgrp -R www-data storage bootstrap/cache
RUN chmod -R ug+rwx storage bootstrap/cache
RUN chown -R www-data: /var/www/html

# USER www-data

EXPOSE 80
CMD ["apache2-foreground"]

FROM php:8.2-apache
#
RUN set -eux \
    && apt-get update \
    && apt-get install -y libzip-dev zlib1g-dev \
    && docker-php-ext-install zip
#
ENV DEBIAN_FRONTEND noninteractive
ENV TZ=Asia/Jakarta

RUN ln -snf /usr/share/zoneinfo/$TZ /etc/localtime && echo $TZ > /etc/timezone

RUN apt-get update --fix-missing
RUN apt-get install -y curl
#COPY src/supervisord.conf /etc/supervisor/conf.d/supervisord.conf
RUN apt-get install -y build-essential libssl-dev zlib1g-dev libpng-dev libjpeg-dev libfreetype6-dev libicu-dev

RUN a2enmod rewrite headers
#RUN docker-php-ext-configure gd --with-freetype-dir=/usr/include/ --with-jpeg-dir=/usr/include/ \
#    && docker-php-ext-install gd

RUN pecl install -o -f redis \
&&  rm -rf /tmp/pear \
&&  docker-php-ext-enable redis

RUN docker-php-ext-install pdo_mysql gd intl

COPY src/000-default.conf /etc/apache2/sites-available/000-default.conf

WORKDIR /var/www/html
COPY src/ /var/www/html/

RUN apt-get -y autoremove
RUN apt-get -y clean
RUN docker-php-ext-install pcntl

RUN curl -sS https://getcomposer.org/installer | php -- --install-dir=/usr/local/bin --filename=composer
RUN composer install --prefer-dist --no-dev -o

RUN php artisan optimize:clear
RUN php artisan config:cache
RUN php artisan view:cache
RUN php artisan route:cache
RUN php artisan icons:cache


RUN chgrp -R www-data storage bootstrap/cache
RUN chmod -R ug+rwx storage bootstrap/cache
RUN chown -R www-data: /var/www/html

# USER www-data

EXPOSE 80
CMD ["apache2-foreground"]

M

Miguel García•2/20/24, 8:55 AM

Some tips from the docs: https://filamentphp.com/docs/3.x/panels/installation#improving-filament-panel-performance

Installation - Panel Builder - Filament

J

Jr.PikongOP•2/20/24, 9:02 AM

Hi @Miguel García , thanks for the advice, there's something I haven't done yet:

artisan filament:cache-components

artisan filament:cache-components

, I'll try it now

R

Raj Siva-Rajah•2/20/24, 9:16 AM

Nova's table load times are faster. It's not a Filament issue, it's a Livewire issue. Nova's tables are rendered client-side (Vue) whereas Livewire has to load / diff / update a lot of Blade components every time a table is (re)rendered. Hopefully someone figures out a way to improve it but it'll never be as fast as a client-side solution. There's some work being done to add loading indicators, which will definitely help "perceived" performance: https://github.com/filamentphp/filament/pull/9958

But as Dennis said, even 1s is too slow for 50 records. And Filament should be rendering 50 records in well under a second too.

J

Jr.PikongOP•2/20/24, 9:24 AM

Hi @binaryfire thanks for your explanation, it helped my insight.

RRaj Siva-Rajah Nova's table load times are faster. It's not a Filament issue, it's a Livewire i...

D

Dennis Koch•2/20/24, 9:26 AM

I think a normal time for Filament is around 300–400ms.

D

Dennis Koch•2/20/24, 9:26 AM

Do you have OPCache enabled?

DDennis Koch I think a normal time for Filament is around 300–400ms.

R

Raj Siva-Rajah•2/20/24, 9:28 AM

Yeah. And less with Octane too!

DDennis Koch Do you have OPCache enabled?

J

Jr.PikongOP•2/20/24, 9:30 AM

no, I didn't set it, but I will explore from this article : https://laravel-news.com/php-opcache-docker

Laravel News

Speeding Up PHP with OPcache in Docker - Laravel News

If you’re on Docker for Mac or Docker for Windows, you might see some noticeable slowness and time to the first byte (TTFB) depending on your application’s setup. One of the most important things you can do to improve performance is enabling the OPCache module. Let’s look at how we can configure OPcache is a way that is development-friendly, but...

JJr.Pikong no, I didn't set it, but I will explore from this article : https://laravel-new...

D

Dennis Koch•2/20/24, 9:32 AM

OPCache is must have when working with PHP

J

Jr.PikongOP•2/20/24, 9:35 AM

thanks @Dennis Koch I will back if done implementing it

J

Jr.PikongOP•2/20/24, 10:33 AM

wow OPcache renders 50% faster than before

Solution

J

Jr.Pikong•2/20/24, 10:44 AM

summary:

run

php artisan icons:cache

php artisan icons:cache

run

php artisan filament:cache-components

php artisan filament:cache-components

run

php artisan optimize

php artisan optimize

implement OPCache

JJr.Pikong summary: 1. run `php artisan icons:cache` 2. run `php artisan filament:cache-c...

R

Raj Siva-Rajah•2/20/24, 10:45 AM

What's the load time for the Filament version now?

J

Jr.PikongOP•2/20/24, 10:48 AM

now is 1.17 s

J

Jr.PikongOP•2/20/24, 10:49 AM

with table record per page 50 .

J

Jr.PikongOP•2/20/24, 10:57 AM

S

S. Mert ÖZTÜRK•2/23/24, 6:24 AM

Still slow. livewire re-render all component for little changes is too big problem. Hope caleb can do something for this on v4. I'm here for some trick, do you try pure pdo for get 50 records on same server, cauz 1.17s is still soooo big

J

Jr.PikongOP•2/23/24, 9:00 AM

Yes, that's right, but with the optimization that has been done, I think it's ok, we can apply a smaller limit, for example, 10 data, and apply a filter.
with the advantages that filament has, it can still be accepted, while waiting for the latest version of Livewire which is better.

Optimizing Table Load Speed

Similar Threads

Similar Threads

Similar Threads