Re: [firebird-support] Name longer than database column size
Hi, i suppose you have name longer in your particular select statement. This can be e.g. in aliasing a field Select a.x as veryLongAliasedNameLongerThen31 from ... But only you can tell in what exact place you got this error Regards,Karol Bieniaszewski null
[firebird-support] Name longer than database column size
Hello. The subject was already discussed before, but I am facing a trouble. I was using FB 2.5 and than I migrated DB to FB 3.0.3. Now when I open my application it shows the message "Name longer than database column size". I searched all the metadata and did not find any object longer than 31 characters. What is wrong? Atenciosamente, + + Hugo Eyng + +
Re: [firebird-support] Re: how can the creation of fb_sort files be avoided? 2.2 GB of fb_sort files
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 > use R: for temp files. > > In older versions of Windows you set up > > TEMP=R: > TMP=R: > > as the environment of a batch file that runs the database - I am out > of touch with Windows now but I guess you can still do something > similar - ask your favourite Windows guru how you do that these days. > > The effect is that the software (both Windows and Firebird) thinks > it's writing normal files but in reality the entire structure > (folders and everything) is built in RAM. > > Just a thought offered in case it helps I think it is easier to change the Firebird configuration of TempCacheLimit as suggested earlier in this thread than to set up a ramdisk. It is probably also better for performance, but I haven't checked that. A ramdisk might be a better choice for Classic though, as in Classic, the TempCacheLimit is per connection. Mark
Re: [firebird-support] Re: how can the creation of fb_sort files be avoided? 2.2 GB of fb_sort files
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 environment of a batch file that runs the database - I am out of touch with Windows now but I guess you can still do something similar - ask your favourite Windows guru how you do that these days. The effect is that the software (both Windows and Firebird) thinks it's writing normal files but in reality the entire structure (folders and everything) is built in RAM. Just a thought offered in case it helps R~~ On Wed, 8 Aug 2018, 03:06 bieten2...@yahoo.de [firebird-support], < firebird-support@yahoogroups.com> wrote: > > > Hi Dalton, Alexey and Dimitry, > > thanks for your answers, I very much appreciate the support. > > It is correct, that I do not want to get rid of the sorting files, I just > want them to stay in RAM where I suspect that it could be advantageous for > performance. > Unfortunately I can't tell you what specific hard drives are in use because > I can't access them, but I was told that they are commercial HDD (not > SSD) . > Raid is most certainly employed, which one I do not know. > The Database File as well as Firebird DBMS are installed on the same > machine. This server is exclusively for the Firebird DBMS + Databases, > there is no other software trying to contest resources. > An ERP Software which is installed on an application-server connects to > the Firebird-DB-Server using port 3050. Said application is made available > to many clients using Windows RDP/ RDS. > Windows RDP/ RDS is not installed on the application server but on > dedicated RDP/ RDS servers. > I have not analysed the queries because I have not written them and lack > the necessary tools (and know-how). Query analysis is an issue that would > require a Firebird specialist. > My hope was, that by following the performance guides, notable performance > increases may be archived. > Optimal results can only be realized with an in-depth analysis, I am very > aware of that but I would like to get the "simple tuning" right first. > Alexey told me, that the TempCacheLimit can be set to 20 GB. > My current setting is 567108864 (540 MB), that's much too low, I will > increase it. > > After reading all the FB guides online I tried to optimize the > Firebird.conf to the best of my ability (see below). > Maybe someone will spot a bad setting and give me a tip :-) > > #RootDirectory = > #DatabaseAccess = Full > #ExternalFileAccess = None > #UdfAccess = Restrict UDF > #TempDirectories = > #LegacyHash = 1 > #Authentication = native > #AuditTraceConfigFile = > #MaxUserTraceLogSize = 10 > DefaultDbCachePages = 2048 > #DatabaseGrowthIncrement = 134217728 > #FileSystemCacheThreshold = 65536 > #FileSystemCacheSize = 0 > #RemoteFileOpenAbility = 0 > TempBlockSize = 2048576 > TempCacheLimit = 567108864 > #CompleteBooleanEvaluation = 0 > #DeadlockTimeout = 10 > #MaxUnflushedWrites = 100 > #MaxUnflushedWriteTime = 5 > #BugcheckAbort = 0 > #OldColumnNaming = 0 > #OldSetClauseSemantics = 0 > #RelaxedAliasChecking = 0 > #ConnectionTimeout = 180 > #DummyPacketInterval = 0 > #RemoteServiceName = gds_db > #RemoteServicePort = 3050 > #RemoteAuxPort = 0 > #TcpRemoteBufferSize = 8192 > #TcpNoNagle = 1 > #RemoteBindAddress = > LockMemSize = 99614720 > #LockGrantOrder = 1 > #LockAcquireSpins = 0 > LockHashSlots = 30011 > #EventMemSize = 65536 > #CpuAffinityMask = 1 > #UsePriorityScheduler = 1 > #PrioritySwitchDelay = 100 > #PriorityBoost = 5 > #GCPolicy = combined > #GuardianOption = 1 > #ProcessPriorityLevel = 0 > #IpcName = FIREBIRD > #RemotePipeName = interbas > #Redirection = 0 > > Best Regards, > James > > >
Re: [firebird-support] How to store a string in Firebird which includes #0's in it?
Hi Hamish Thanks for introducing float to this discussion: the varying ways different architectures store the 'same' float (like 3.0e8 for example) amplify the point I was making. A float is stored in binary. That is not suggesting that it is stored as the base2 coding of it as an integer. It is acknowledging that the only way modern digital media store anything as some binary coding scheme. So a float is encoded somehow as binary. I don't usually say 'encoded' because everything is encoded, even standard integers have a choice of whether and how negatives are stored. And the choice of which way round to code a zero or one into the physical medium is itself a coding standard. I am suggesting that it is just as valid to talk about it being stored in hex as binary: both impose a numerical representation that is not usually directly relevant to what is being remembered. Hex is a more compact form of binary because each hex digit represents four bits, and I know what those bits are just by looking. So my habit, my gut feeling, my intuition, is that any binary pattern can just as well be written as hex. It is just notation. If you are happy to know that the postultimate byte of a C string is a byte with all its bits zero then it is valid to say that as binary b or as hex x00. Which is easier to type? to understand? I am going to apply that intuition to float, inspired by Hamish's point. Some readers will want to leave at this point... A Float is encoded differently to an Integer - Some range of bits is understood to be mantissa and some others the exponent. True. But that fact is not stored in memory along with those bits. The bits of the mantissa and exponent are stored as naked bits leaving the hardware or software to interpret them. ((students seem to find the expression "naked bits" a memorable mnemonic)) When you define a variable type in a language, or a field type in a database system, you are defining two things. Firstly how the bits are processed - are they interpreted as a base 2 integer, as a BCD integer, as a float, etc, or even as machine code. If it is a float, is the mantissa defined to base 2 or base 16? (Both have existed in my programming career). Secondly presentation: how they are displayed on output. The point I was originally making was that any bit pattern can be displayed in hex, as well as the obvious format for that type. That is why hex is used for core dumps. If hex couldn't represent everything they'd use something else. An interesting example of this is the EICAR string which is a string of printable characters that when coded in 8bit ascii and loaded into an x86 actually runs as valid machine code! Is the EICAR code a character string or instruction code? Or hex? I am saying it is any of these, all of them at once. Coming back to Float. Ask me how NEGINF (float negative infinity) was stored in a CDC7600 and at one time I would have given you the answer in hex. The hex value will not (of course) be intended to mean it's an integer with that base16 value. NEGINF is by definition a lot further from zero than any storable integer. But it still has a hex value. If asked how some specific float value like 3.0e8 is stored in two different architectures and the most manageable way to answer is in hex. So in my opinion it is never wrong to say some octet is hex 00, just as it is never wrong to say it is binary . So to go back to the original point I disputed, I personally intend to go on referring to the byte terminating a C string as being x00 not as the more pedantically correct chr(0). I respect the counter argument that I might mislead people to code the ascii characters for the hex digits. I can see the sense of that advice but it doesn't persuade me to change the habits of a professional lifetime. R~~ On Wed, 8 Aug 2018, 00:35 Hamish Moffatt ham...@risingsotware.com [firebird-support], wrote: > > > 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 of presentation but of > encoding. Floats are stored encoded as sign, mantissa, and exponent. > > https://softwareengineering.stackexchange.com/questions/215065/can-anyone-explain-representation-of-float-in-memory > > Integer versus fixed point is a matter of presentation perhaps, but not > floating point. > > Hamish > > hi >