Уровень 0 · материалов: 6
В кластер входят документы, описывающие конкретные технические методы оптимизации производительности и работы с данными в программном обеспечении.
Общие признаки: повышение эффективности работы приложений, оптимизация баз данных, управление ресурсами и нагрузкой, технические архитектурные решения
Группа выше: Оптимизация производительности кода
Смысл: The main idea is that adding complex new features (like building entrances) to a data-heavy offline application can be achieved without increasing storage costs by systematically optimizing data structures, compression algorithms, and removing redundant legacy information.
2GIS integrated building entrance and apartment search into their maps while reducing overall database size by 10% through advanced binary formatting and compression.
Смысл: The text explains the technical infrastructure of the lsFusion platform, focusing on how it manages complex project structures, integrates with external environments, and optimizes database performance to handle enterprise-level data loads.
A technical deep dive into lsFusion's physical architecture, covering namespaces, modularity, metaprogramming, system integration, data migration, and database optimization techniques.
Смысл: The text argues that traditional offset-based pagination is flawed due to data inconsistency and performance issues, and advocates for a two-step process: first fetching a list of IDs (snapshot) and then fetching the specific data associated with those IDs.
Offset-based pagination causes data duplicates and performance lag; a better approach is to separate the search for IDs from the retrieval of actual data.
Смысл: The author argues that for high-traffic sites, updating counters and feeds via triggers during a write operation is significantly more efficient than calculating them on the fly during a read operation.
The author advocates for using SQL triggers to handle counters and event logs in high-load systems to reduce read-time latency.
Смысл: The main idea is to teach developers how to optimize Angular application performance by replacing the resource-intensive Default change detection with the OnPush strategy, utilizing immutable data and manual change triggers.
A technical deep dive into optimizing Angular performance by using ChangeDetectionStrategy.OnPush to reduce unnecessary component re-renders.
Смысл: The main idea is to demonstrate a practical architectural pattern for integrating the proprietary 1C platform with external applications using Python, overcoming performance and compatibility hurdles by implementing a data caching layer (SQLite).
The author explains how to use Python and COM connectors to extract data from 1C into an SQLite database to enable fast, platform-independent access for web applications.