database.sarang.net
UserID
Passwd
Database
DBMS
MySQL
PostgreSQL
ㆍFirebird
Oracle
Informix
Sybase
MS-SQL
DB2
Cache
CUBRID
LDAP
ALTIBASE
Tibero
DB 문서들
스터디
Community
공지사항
자유게시판
구인|구직
DSN 갤러리
도움주신분들
Admin
운영게시판
최근게시물
Firebird Q&A 852 게시물 읽기
No. 852
What is the benefit of Vulcan or Firebird 3 ?
작성자
이ㄱ며ㅇ
작성일
2011-08-20 00:55ⓒ
2011-08-20 00:56ⓜ
조회수
32,334

 

FirebirdSQL RDBMS (Database System)

 

http://www.firebirdfaq.org/faq208/

 

What is the benefit of Vulcan or Firebird 3 ?

 

The main benefit will be a multithreaded engine that can use multiple CPUs effectively.  Current versions of Firebird have problems:

SuperServer does not work on multiple CPUs at all.  You have to set CPUAffinity in firebird.conf to lock it to a single processor.  This is fine when load is not big and your machine acts as something else as well (web server for example), so other applications can use the other CPU.  However, it does not do SMP work.

Classic works fine with SMP, but doesn't scale very well.  The main problem are locks which are delivered between processes using signals.  If you have a lot of connected users (300 for example) on Quad CPU machine,  it would mean that all 300 processes need to get lock info from those 4 processes using the database.  This communication clutter creates a lot of traffic and load.  A proper multithreaded engine that can work on multiple CPUs would solve this, as the communication would be done within a single process without hogging the operating system facilities.

 

 

 

 

[Top]
No.
제목
작성자
작성일
조회
891Firebird SQL Project News
2012-01-28
31863
890(LINK) Firebird SQL Project News
2012-01-28
31510
889Firebird 2.5.1 Released October 04, 2011
qqdd
2011-12-05
32152
852What is the benefit of Vulcan or Firebird 3 ?
이ㄱ며ㅇ
2011-08-20
32334
851FirebirdSQL v3.0 - Scalable (SMP/multi-core friendly) multi-threaded engine
이ㄱ며ㅇ
2011-08-20
33137
849blob containing 또는 like 검색 문의
김상윤
2010-09-25
33688
841IBPP사용하는데 [1]
안지훈
2010-01-26
28698
Valid XHTML 1.0!
All about the DATABASE... Copyleft 1999-2023 DSN, All rights reserved.
작업시간: 0.050초, 이곳 서비스는
	PostgreSQL v16.1로 자료를 관리합니다