Firebird used on a site with 1 Million users / day

Q:What kind of system is this? .The response is on Firebird-support

Monitoring software with also web access by many many users ~1 000 000
They do something which need transaction and some select(reports) which “not need” transaction
but in transactional database select also start short transaction then i can not remove it creation..
1 000 0000 x 10 queries per day i got 10 000 000 transaction+ system self generate 8 000 000 transaction per day (to
storing/updating/computing.. data)
and Forced Writes are ON but database work on some not mechanical device like normal HDD and corruption is reduced to minimal possible but this transaction counter do may problem :/

Karol Bieniaszewski

(7 votes, average: 5.00 out of 5)

Average of Firebird users DB sizes

In a recent survey for the next Firebird Developers Day in Brazil, one of the questions was about the average size of the participants (and/or their customers) databases. A total of 344 people answered, and the result can be seen below:

In general, your (or your customer’s) database has…

---------------
Percent Count Answers
---------------
20.3% 70/344 up to 500MB
31.1% 107/344 up to 2GB
20.9% 72/344 up to 5GB
17.2% 59/344 up to 10GB
10.5% 36/344 more than 10GB
---------------
100.0% 344/344 Summary
---------------

PS: Note that this survey was directed only to people who intends to participate in the next Brazilian FDD edition.

(4 votes, average: 5.00 out of 5)

(4 votes, average: 5.00 out of 5)

(3 votes, average: 5.00 out of 5)

(1 votes, average: 5.00 out of 5)

(5 votes, average: 5.00 out of 5)

(4 votes, average: 5.00 out of 5)

(3 votes, average: 4.67 out of 5)

(5 votes, average: 5.00 out of 5)

Tip: Using isql-fb / isql with readline in Debian/Ubuntu instead of libedit

Seems that readline does have utf-8 support and can be used for inserting/selecting accented chars
Check if libedit is used instead of readline

ldd /usr/bin/isql-fb | grep libedit
libedit.so.2 => /usr/lib/libedit.so.2 (0x00007f3dcbd7b000)

export LD_PRELOAD=/lib/libreadline.so.6

check if is preloaded

ldd /usr/bin/isql-fb | grep readline
/lib/libreadline.so.6 (0x00007fc661d22000)

Then use isql-fb as usual

SQL> select * from employee where first_name = ‘ő’

(No Ratings Yet)

1 … 226 227 228 229 230 … 495