<< it may be worth considering and adjunct piece of software to Firebird,
called "HqBird", which uses Firebird as its base database engine. "HqBird" was
designed for Firebird databases that are by necessity very large and require
more power and capabilities than the standard version may offer.
On 2018-08-08 20:58, 'River~~' river14ap...@gmail.com [firebird-support]
wrote:
> Suggestion: if you have admin rights on the machine install a ramdisk
> (there are several available for Windows and MS themselves offered
> them for some earlier Windows versions) as say R: and tell Windows to
>
Suggestion: if you have admin rights on the machine install a ramdisk
(there are several available for Windows and MS themselves offered them for
some earlier Windows versions) as say R: and tell Windows to use R: for
temp files.
In older versions of Windows you set up
TEMP=R:
TMP=R:
as the
Hi James,
I have a couple of questions about your configuration before I give any
suggestions.
You specify you are wanting to get rid of sort files. Sort files are a
tool the engine uses to hold information before sending them to the user.
Depending upon your queries, sort files are required
Hello,
Since you have enough RAM, you can increase TempCacheLimit in
firebird.conf, for example, set 20Gb.
Fb_sort_xxx files will be created only if sorting will require more than
TempCacheLimit.
Regards,
Alexey Kovyazin
IBSurgeon
On 07.08.2018 10:35, bieten2...@yahoo.de [firebird-support]
07.08.2018 9:35, bieten2...@yahoo.de [firebird-support] wrote:
> it would be great if I where to receive an answer to this question :-)
> I am unsure whether the issue is so easy to answer that everyone thinks it is
> self explanatory
Sort files are created when you issue queries with plan