Re: [Firebird-devel] Dmitry K :: Re: Fw: Limit/Top syntax with Firebird

[Sergey N. 2. <se...@ma...>]

Hello, Helen!
You wrote  on Sat, 12 Jan 2002 01:51:18 +0000 (UTC):

 >>> http://www.private.peterlink.ru/rcav/index.htm

 >>> http://www.private.peterlink.ru/rcav/download.htm

 >>> Original build of FB also know as Yaffil

 HB> Dmitry, if you're reading this, would you please do me a favour?

I not Dmitry, but shall try to answer your questions

 HB> (a) which build this is equivalent to (if possible) & build dates;  and
=========Beginning of the citation==============
The current version is similar FireBird build 702
The code is as much as possible synchronized with initial code FireBird. We
more do not plan to make what or essential changes to the current version of
Yaffil. superserver i.e. Yaffil - 100 % compatible with FireBird the server
with the improved productivity. The basic work will be now directed on
operational development of the classical version of the server under Win32.
Subsequent assembly Yaffil will reflect changes of code FireBird. With
releases
FireBird authors issue Yaffil 1.0, based on final code FireBird

=========The end of the citation================

 HB> (b) a list of the extra features referred to

=========Beginning of the citation==============
The description of parameters ibconfig
 FORCE_RESHEDULE
THREAD_QUANTUM
SWEEP_THREAD_QUANTUM
REJECT_AMBIGUITY
SQZ_RECORD
SQZ_RATIO
WIN32_DISABLE_FILE_CACHE
LOCK_TIMEOUT

FORCE_RESHEDULE 1
Improves the response of the superserver in execution time heavy
"Searches / procedures". During work of the server in addition initiates
the internal scheduler.
THREAD_QUANTUM 100
Priority of a thread of the superserver by default. Through some
Operations the cursor reduces this value on 1. As soon as reaches up to 0,
Compulsorily transfers management to other thread. In standard variant it
constant.
SWEEP_THREAD_QUANTUM 5
Similarly THREAD_QUANTUM, but for a thread sweep
SQZ_RECORD 32
The size of recording since which packing begins. I.e. recordings, the size
< = SQZ_RECORD are not packed. Works, since 505.5
SQZ_RATIO 80
Intellectual rating of packing. The algorithm excludes "short" blocks
Packings, uniting them in larger, proceeding from a ratio
Speed / degree of compression. At the present moment it is developed.
WIN32_DISABLE_FILE_CACHE 0
Disconnects caching by means of OS of a file of a database
LOCK_TIMEOUT-1
Timeout blocking for the transactions started as WAIT. The positive number
defines(determines) Timeout in seconds, the maximal value 32767. The
negative number sets infinite expectation. Zero value transforms WAIT
transactions in NOWAIT. The parameter does not render influence on
transactions started as NOWAIT. A default value-1 (a minus one).

 Sorting it is altered on temporary files with attribute
FILE_ATTRIBUTE_TEMPORARY


   As to the initial text
   The algorithm of work of the manager " dirty page " (pages is completely
copied
Changed(changeable) within the framework of transaction), a file nnh.c,
functions btc_*-
Unbalanced tree has replaced on balanced (AVL)
   Are completely copied on asm functions of work with indexes
btr.c/BTR_find_leaf, btr.c/find_node (from search in an index),
sqz.c/SQZ_decompress, sqz.c/SQZ_fast
   Are added asm inserts in a code of functions - btr.c/compress,
sort.c/diddle_key,
sort.c/get_merge And still somewhere:-)
   In winnt.c the file handle for a mode force_write is removed(cleaned),
and is realized
The variant of processing of this mode + correct opening of a file.
   Improvements on a code (inserts memcpy, memset, pragm the compiler

Missing functionality of  XNET protocol Is realized

On optimization, replacement define etc. from the point of view of
productivity)

   Additional system indexes:
index RDB$INDEX_41 for RDB$TYPES RDB$FIELD_NAME;
index RDB$INDEX_42 for RDB$INDICES RDB$FOREIGN_KEY;
index RDB$INDEX_43 for RDB$RELATION_CONSTRAINTS RDB$RELATION_NAME,
RDB$CONSTRAINT_TYPE;
   The Statistics of system indexes is automatically updated at the moment
restore.


=========The end of the citation================

 HB> (c) whether this is an installation kit or just binaries

just binaries  and sources

http://www.private.peterlink.ru/rcav/download.htm

Developers -
Oleg LOA (lo...@ma...)
Alexey  Karyakin   ( kar...@cm...)


ps Excuse me for a my poor english

___________________________________
Sergey Nikolaenko se...@ma...
[FIBPlus Test Team]      www.fibplus.com.ua