Subject | Back to firebird - 10 questions |
---|---|
Author | tjelvare |
Post date | 2007-10-26T08:12:32Z |
Used firebird a lot for a production system
around 2000-2001, thankful for advices regarding following:
* Is cpuAffinity in firebird.conf a win32 feature only?
(I want to force fb-ss to one cpu on a dual core, considering
linux taskset)
* Need case-insensetive indexes, used iso-8859-2 and collate sv_sv,
but what about UTF8. How to best get ci-searches. Specifying
UTF8-subtype, or collate in every sql-query? (Second must mean
worse performance??)
* UTF8 production stable? Internal functions support...?
Good or bad experiences?
* Many tools, (ibo-console) doesn't talk UTF8, recommended tools?
* I need to convert a ms-sql database to firebird, but sql2gdb
doesn't talk utf8. Has anyone a suggestion for a quick fix?
(Looking at the sounce is a bit overkill for me, but maby just
to update the client-library??)
* Need a quick overview of the triggers/sp-language, any good guide
around. (Used it alot back in 2001)
* What's the status regarding vulcan (true SMP).
Many wants it, right? Status? Schedule? Fund-raising?
* Recommended filesystem for firebird? ext3 good enough?
* does LIKE always go natural?
:select * from tbl where fld>='a' and fld<'b' => plan: idx_fld
:select * from tbl where fld like 'a%' => plan: natural
* Firebird deserves a nice homepage. (no offence...)
Anyone working with this?
All the best,
tjelvar
around 2000-2001, thankful for advices regarding following:
* Is cpuAffinity in firebird.conf a win32 feature only?
(I want to force fb-ss to one cpu on a dual core, considering
linux taskset)
* Need case-insensetive indexes, used iso-8859-2 and collate sv_sv,
but what about UTF8. How to best get ci-searches. Specifying
UTF8-subtype, or collate in every sql-query? (Second must mean
worse performance??)
* UTF8 production stable? Internal functions support...?
Good or bad experiences?
* Many tools, (ibo-console) doesn't talk UTF8, recommended tools?
* I need to convert a ms-sql database to firebird, but sql2gdb
doesn't talk utf8. Has anyone a suggestion for a quick fix?
(Looking at the sounce is a bit overkill for me, but maby just
to update the client-library??)
* Need a quick overview of the triggers/sp-language, any good guide
around. (Used it alot back in 2001)
* What's the status regarding vulcan (true SMP).
Many wants it, right? Status? Schedule? Fund-raising?
* Recommended filesystem for firebird? ext3 good enough?
* does LIKE always go natural?
:select * from tbl where fld>='a' and fld<'b' => plan: idx_fld
:select * from tbl where fld like 'a%' => plan: natural
* Firebird deserves a nice homepage. (no offence...)
Anyone working with this?
All the best,
tjelvar