Hello,

we have a web site with PHP5.3 and firebird 2.5 database. Some queries that
search in heavy tables, about 1,8 million of records, with joins to other
tables, makes 100% of cpu. We have about 50 users concurrent connected
(hits per second), so the users have to wait to the last

I was wondering to know if we can set the max limit per thread or process
(we tried with SuperServer, Superclassic and Classic server).

GSTAT.
Flags 0
Checksum 12345
Generation 1440472
Page size 4096
ODS version 11.2
Oldest transaction 1408045
Oldest active 1439307
Oldest snapshot 1439298
Next transaction 1439312
Bumped transaction 1
Sequence number 0
Next attachment ID 147529
Implementation ID 24
Shadow count 0
Page buffers 0 (we tried with 4000 too)
Next header page 0
Database dialect 3
Creation date Feb 22, 2013 12:08:22
Attributes force write

Variable header data:
Sweep interval: 50000 (we tried with 0 too)

Thank you
Santi


[Non-text portions of this message have been removed]