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 174 게시물 읽기
No. 174
Why is the connection to the server so slow?
작성자
궁금이
작성일
2009-03-05 04:30
조회수
8,357

What's the difference between Classic and Super Server?
http://www.firebirdfaq.org/faq25/

Does Firebird support SMP?
http://www.firebirdfaq.org/faq2/

Why is the connection to the server so slow?
http://www.firebirdfaq.org/faq52/

2. If you have CPU that supports hyperthreading try disabling it to see if that helps. If you can multi-core CPU (dual core, quad core), set the CPUAffinity setting in firebird.conf

 

이 글에 대한 댓글이 총 2건 있습니다.

hi.

first, I can't english very well with this understanding.

what do you mean "SMP"

maybe I think about that "symmetric multiprocessing" 
correct?

>Does Firebird support SMP?
sure! Use the Classic
latest version is no problem.
but somtime, old version make a problems.( Fb1.5.x, 2.X ,etc) 

If you use SuperServer, limit to 1 core because of problems. If you use
Classic multiple cores will be used (for different connections!).
Otherwise you will have to wait for Firebird 2.5 (or use the Alpha :)
which introduces better SMP support.

> Why is the connection to the server so slow?
it is case-by-case basis

in firebird.conf:

CpuAffinityMask = 6

do you have an another question?

gook luck!

님이 2009-03-14 06:28에 작성한 댓글입니다. Edit

글쓰는 시간동안 세션이 날라가 버렸네 ㅠㅠ;;;

이창민(prosper)님이 2009-03-14 06:30에 작성한 댓글입니다.
[Top]
No.
제목
작성자
작성일
조회
177멀티 DB 파일 만드는 방법이요.. [2]
강레지나
2009-03-10
9347
176"쓰기 성능"이 훌륭한 / 괜찮은 DBMS제품 추천부탁드립니다. [1]
궁금이
2009-03-08
9760
175Firebird JDBC - Firebird Development : Jaybird JDBC/JCA Drivers [1]
궁금이
2009-03-05
9132
174Why is the connection to the server so slow? [2]
궁금이
2009-03-05
8357
173Does Firebird support SMP?
궁금이
2009-03-05
7883
172What's the difference between Classic and Super Server?
궁금이
2009-03-05
7736
171Linux상에서도 Dual Core나 SMP에서 에러없이 잘 돌아갑니까? [1]
궁금이
2009-03-05
7712
Valid XHTML 1.0!
All about the DATABASE... Copyleft 1999-2023 DSN, All rights reserved.
작업시간: 0.050초, 이곳 서비스는
	PostgreSQL v16.1로 자료를 관리합니다