Начало » Использование СУБД » Firebird, HQbird, InterBase » Ссылка на библиотеку статей на английском языке (Ссылка на библиотеку статей на английском языке)
Ссылка на библиотеку статей на английском языке [сообщение #31] |
Fri, 17 June 2022 12:30 |
ak
Сообщений: 5 Зарегистрирован: June 2022
|
Junior Member |
|
|
Ссылка в сообщении ниже
Contents
Performance
Transactions
Performance tests
Firebird Performance Newsletter
Firebird database performance optimization service
Recovery
Encryption of Firebird databases
Hardware & Cloud
Backups
Troubleshooting
Installation and Configuration
Migration
Basics (data types, tables, generators, indices, views)
Useful pieces around Firebird: tips, tricks, jokes, and how-to
IBSurgeon Tools Guides
Performance
Short Firebird database performance checklist (!)
23 More Ways To Speed Up Firebird (!)
45 Ways To Speed Up Firebird Database (!)
Optimized Firebird configuration files (!)
How to make Firebird work 20% faster on Windows Server 2016 in less than 1 minute
Using prefix date to speed up queries with DATE columns
How to make Firebird consume a lot of memory?
Negative impact of indices to INSERT, UPDATE and DELETE performance in Firebird SQL
nbackup with switch -D ON does not work on ZFS
Transactions
How Firebird Transactions work (!)
How to track deadlock in Firebirds (!)
Performance tests
Simple INSERT/UPDATE/DELETE test (!)
Quick estimation of disk speed with backup
Firebird OLTP-EMULator
Firebird performance degradation: tests, myths, and truth - 1.7Tb, part 1
More details about 1.7 Terabyte Firebird SQL database - 1.7Tb, part 2
Tuning 1.7 Terabyte Firebird SQL database - 1.7Tb, part 3
1 Tb Firebird database: a preliminary report
Firebird Performance Newsletter
Issue 1: Firebird 4 vs Firebird 3 Write Performance, Choosing AWS EC2 instance for Firebird, etc
Firebird database performance optimization service
Optimization service: description, fees, details
Questionary: Required information for Firebird database performance optimization
Recovery
In case of a heavy corruption
FirstAID Recovery tool
Firebird/InterBase recovery service
Light corruptions, and general information about corruptions and their fixing
How to repair a corrupt Firebird database? (!)
Short explanation of gfix.exe output (!)
How to find and delete duplicate records in Firebird database
"Cannot commit index" or how to pump data from partially restored (inconsistent) database (!)
Fighting Petya: our experience with retrieving data from the Firebird database files encrypted by ransomware crypto-viruses
Common InterBase/Firebird errors caused by corruptions and their recovery chances
How to protect Firebird databases from ransomware?
Internal gds software consistency check - full list of serious Firebird/InterBase errors
How to check RAM and avoid database corruptions
How to quickly check RAM on Linux
Internal gds software consistency check - how to recover Firebird/InterBase databases (2014)
InterBase and Firebird Recovery Guide (chapter from "The InterBase World" book)
Encryption of Firebird databases
How Firebird Database Encryption Works
Demo package with sources and step-by-step instructions of Firebird database encryption plugin
Connect to encrypted database with developer tools
Hardware & Cloud
Choosing the best AWS EC2 instance for the maximum Firebird write performance
Firebird Hardware Guide (!)
How to install Samsung NVME SSD disk driver on Windows Server
Fast, Furious, and Cheap: server with good-enough performance for small business database for less than US$1000 (deprecated)
Backups
Firebird Gbak Tips And Tricks
12 Common Mistakes while Backing Up Databases (!)
Troubleshooting
How to configure Firebird crash dumps collection on Windows
Errors in Firebird.log
How to crash Firebird server
Installation and Configuration
Installing Firebird 3 on modern Linux versions: CentOS 8 and Ubuntu 19 (!)
How to use instreg.exe and instsvc.exe (command line tools for Firebird installation on Windows)
How to make Firebird 3 connect like 2.5 with embedded connection string
How to enable or disable connection protocols for Firebird on Windows
How to enable Firebird to work through network protocol at CentOS 6.x
fb_lock_print parameters explained
Firebird 3 Setup Command line parameters
Firebird 3 Database Server installation
Migration
Short Firebird 4 Migration Guide (in PDF)
Fast conversion of Firebird 2.5 databases to Firebird 3.0 (!)
Testing application’s queries (the excerpt from "Migration Guide To Firebird 3")
Differences between Firebird and InterBase
All Firebird and InterBase On-Disk-Structure (ODS) versions
How to migrate (copy) users from security2.fdb (Firebird 2.5) to security3.fdb (Firebird 3.0)
List of known incompatibilities between Firebird v 2.x and 30
List of known incompatibilities between Firebird 2.x and 2.5
Migration service (!)
Basics
Data types
Tables. Primary keys and generators
Database constraints in Firebird and InterBase
Indices (InterBase and Firebird)
Views (InterBase and Firebird)
Database physical structure (InterBase and Firebird)
Useful pieces around Firebird: tips, tricks, jokes, and how-to
Firebird Stored Procedure to split line with delimiters to recordset
Firebird 3.0 users with the same names but different passwords (!)
How to "inflate" Firebird database with temporary blobs (!)
How to estimate number of records in the table using statistics value of the unique index
How to execute SQL command with isql in command prompt
How to determine Firebird architecture with SQL query? (!)
How to put 29 characters into VARCHAR(10)
Built-in Firebird 3.0 functions (SDF aka Server Defined Functions)
All issues of "The InterBase and Firebird Developer Magazine" (!)
Firebird Conference 2014 report
Firebird GUI Tools
Firebird 2.5: Autonomous Transactions
Alias handling and ambiguous field detecting in Firebird 2.0
Firebird Index Structure for Firebird 2.0 (ODS 11 and higher)
The differences between VARCHAR and INTEGER fields in keys
Space allocation in Firebird 2.1 and higher
Fixes in Firebird 2.5 regarding connection string charset
Maximum table size in InterBase (before version 2009)
Firebird 2.0 garbage collector
IBSurgeon Tools Guides
HQbird User Guide (and in PDF)
FirstAID Recovery Guide: English, Russian, Portuguese
FBScanner User Guide (outdated): English, Portuguese
Database Analyst (ex-IBAnalyst) optimization articles
How to get statistics from InterBase/Firebird database in the right way
What you can see at Summary View
Understanding Your Database
Tips and Tricks
|
|
|
|
|
|
|
|
Переход к форуму:
Текущее время: Sun Dec 22 09:33:08 GMT+3 2024
Общее время, затраченное на создание страницы: 0.01117 секунд
|