Performance
- Does the order of where clauses or columns in where clause affect the query speed?
- Firebird SuperServer running at 100% CPU?
- Firebird server is very slow, using 100% of system resources, etc.
- Help, I'm losing data?
- How to prevent database file fragmentation?
- Is it a good idea to create index on field with only a few different values?
- Is it possible to create an index on expression?
- Is there a difference in performance between primary key and an index?
- Is there a way to prevent primary key, foreign key and unique constraints from creating an index?
- Long running query hogs the server, why?
- Select count(*) is slow
- What is index selectivity?
- Why doesn't Firebird use index in my NOT something query?
- Why doesn't LIKE 'A%' always behave the same as STARTING WITH 'A'?
- Why doesn't MAX(Primary key field) use index?
- Why doesn't my query plan use index?
- Why is database cache not used by Firebird with my web application?
- Why is my database query slow?
- Why is my query much slower when in view?
- Why is my query that uses IN or NOT IN slow?
- Why is the connection to the server so slow?
Copyright © 2007-2024 FirebirdFAQ.org
The Firebird FAQ