Skip to content
DealAI.lt Documentation

Performance Optimization

Performance Optimization

Section titled “Performance Optimization”

Best practices for optimizing DealAI.lt performance.

Database Optimization

Section titled “Database Optimization”

Indexing

Section titled “Indexing”
  • Add indexes on frequently queried columns
  • Use partial indexes for filtered queries
  • Monitor index usage

Query Optimization

Section titled “Query Optimization”
  • Use prepared statements
  • Implement connection pooling
  • Batch operations
  • Optimize joins

Elasticsearch Optimization

Section titled “Elasticsearch Optimization”

Index Settings

Section titled “Index Settings”
  • Appropriate shard count
  • Replica configuration
  • Refresh interval tuning

Query Optimization

Section titled “Query Optimization”
  • Use filters over queries
  • Limit result size
  • Cache frequent queries
  • Optimize aggregations

PHP Optimization

Section titled “PHP Optimization”

OPcache

Section titled “OPcache”
opcache.enable=1
opcache.memory_consumption=256
opcache.max_accelerated_files=10000

Memory Management

Section titled “Memory Management”
  • Set appropriate memory_limit
  • Implement garbage collection
  • Batch process large datasets

Caching

Section titled “Caching”

WordPress Object Cache

Section titled “WordPress Object Cache”
  • Redis or Memcached
  • Cache search results
  • Cache database queries

Next Steps

Section titled “Next Steps”