Answer the question
In order to leave comments, you need to log in
Firebird 2.5 (speed up city database)?
firebird 2.5
with databases work in read mode 80% of the time
, as many as 3-10 users. more often 4
iron
screw sata3-16mb cache,
stone i3 3200,
ddr3 4gb,
starting seven - axis, on the server the user in the office makes printouts and there is also a file trash - on a separate logical disk, a local ball ...
on a partition with a database (25 GB) cluster = 16kb ntfs + daily backups are
4-6 GB database, re-indexing once a year, you can once a month
100Mbit local,
city-scale database - 100 thousand to 500 million records firebird 2.5
it's a shame that the CPU is not loaded ...
on Linux i5 650+ddr3 8gb+sata3 - flew three times faster!
how to speed up? what to measure?
experimented with a large cache and virtual disk and wasted
changing the file system and defragmenting? mess with the network? change the packet length?
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question