Re: [firebird-support] How to store a string in Firebird which includes #0's in it?

2018-08-07 Thread Hamish Moffatt ham...@risingsoftware.com [firebird-support]
On 04/08/18 23:06, 'River~~' river14ap...@gmail.com [firebird-support] wrote: To say an octet is in hex is no more wrong than to say some number is stored as a float. It's all just a bucket of bits. Hex or float or Integer are always presentation Float or integer is definitely not a matter

Re: [firebird-support] Re: how can the creation of fb_sort files be avoided? 2.2 GB of fb_sort files

2018-08-07 Thread Dalton Calford dalton.calf...@gmail.com [firebird-support]
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

Re: [firebird-support] Re: how can the creation of fb_sort files be avoided? 2.2 GB of fb_sort files

2018-08-07 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
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]

Re: [firebird-support] Re: how can the creation of fb_sort files be avoided? 2.2 GB of fb_sort files

2018-08-07 Thread Dimitry Sibiryakov s...@ibphoenix.com [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