- Goto Message #
Re: database gone after server reboot ... Perhaps a different client library gds32.dll/fbclient.dll is loaded? Are you running InterBase and Firebird in parallel on the same machine? -- With
Re: Is there any benefit when using Firebird Classic in 64bit versio ... In general, they are wrong. ;-) ... High RAM utilization doesn't necessary result in best performance. Usually, already with some conservative base
Re: Is there any benefit when using Firebird Classic in 64bit versio Thanks, I've read the article. Unfortunatelly it is irrelevant to my question, because I asked specifically about FB Classic and tests were conducted on
Fetching Sponsored Content...
Re: Is there any benefit when using Firebird Classic in 64bit versio In the real field 64 makes more sense here is one of the firebird customers comparing x32 vs x64 and they really benefit from 64 bit version speedup
Re: Is there any benefit when using Firebird Classic in 64bit versio ... Classic ... I don't think using 64 bit with classic adds a lot, however sometimes dependency- and management-wise having all 64 bit libraries on a 64 bit
Re: Please help me out in tuning out our Firebird server. Thank you jimi. I've read the mentioned article, it gave me a lot of input but still I do not get this FileSystemCacheThreshold variable..
Re: Is there any benefit when using Firebird Classic in 64bit versio ... How could I miss that? Really I should give up this web interface and switch to e-mail. Thanks Mark! Could please give me your opinion on using 64 bit in
Re: Is there any benefit when using Firebird Classic in 64bit versio ... https://groups.yahoo.com/neo/groups/firebird-support/conversations/messages/124144 ...
Re: Is there any benefit when using Firebird Classic in 64bit versio First of all Thomas, thank you very much for your response. As I am sure you know there is this 64 bit hype around and people will install 64 bit versions of
Re: Efficient subselects Josef ... Did you consider using selectable EXECUTE BLOCK, where you iterate master table with FOR SELECT statement and get the aggregate values from DETAIL
Re: Efficient subselects ... Interesting approach. I will consider it, maybe it would be sufficient for my needs. Thanks! Josef
Re: Efficient subselects ... Hi! Unfortunately, this is not applicable to my case, as I do have MASTERs which have no DETAIL (yet). Josef
Re: Is there any benefit when using Firebird Classic in 64bit versio ... I guess you are running with the default 75 page buffers, as well with low in-memory sort settings etc. A great playground for Firebird consulting
Re: Efficient subselects Hi Josef ... I would consider the this second option, but I would change the join: SELECT ... FROM DETAIL LEFT JOIN MASTER Check on your real structure and
Re: Efficient subselects Hi Josef, what I figured out to be quite handy, is to write something like: select MASTER.*, cast(left(S, 10) as bigint), cast(substring(S from 10 for 10) as
Fetching Sponsored Content...
Efficient subselects Hi! I am struggling with a particular select, trying to get it to execute as efficiently as possible. I have tables MASTER(ID, NAME, ...) and DETAIL(ID,
Is there any benefit when using Firebird Classic in 64bit version? Hi guys, I just wanted to ask about that. Because every firebird process on my machine is taking about 8-20 MB RAM. The obvious reason to use 64 bit
Re: Why does the embedded client require security2.fdb on mac? Hi Helen, Thanks for your response and explanation. I forgot to mention that we are using 2.5.2. The interesting scenario that this lack of parity breaks on
Re: Why does the embedded client require security2.fdb on mac? ... In the existing releases of Firebird the "embedded" model on Windows is different from on POSIX. -- on Windows, the client connects to the database via
How to login to a local database without password? How can I attach to a local firebird database? I have a program that was originally written for Interbase but I wanted to run it against a firebird database.
Re: database gone after server reboot How can I attach to a local firebird database? I have a program that was originally written for Interbase but I wanted to run it against a firebird database.
Re: database gone after server reboot On Fri, 18 Apr 2014 08:18:02 +1200, Helen Borrie ... described ... way ... or ... that ... and ... I believe there are actually several
Why does the embedded client require security2.fdb on mac? I took a look at the code and jrd/pwd.cpp has pretty much all the security contents commented out if EMBEDDED compiler definition is set. This seems to be
Re: database gone after server reboot ... I don't know why you ask this question. RESERVE is the default (and recommended) setting for a read/write database. It can be set OFF for a read-only
Re: Using PSQL as a function? Sean, ... Yes, of course. That's another option. ;-) -- With regards, Thomas Steinmaurer http://www.upscene.com/ Professional Tools and Services for Firebird
Re: Using PSQL as a function? ... Ah, even more to look forward to with v3. ... Thanks, that makes sense. Scott
Re: Using PSQL as a function? Thomas, ... Another approach, would be to use the SP as a table and join to it, as in: select t.c1, SP. rvalue as proc_value from mytable t LEFT JOIN
Fetching Sponsored Content...
Odp: [firebird-support] Using PSQL as a function? Hi, You must select from somewhere E.g. use Select c.valc ,(Select p.val from myproc(123)) From sometable Regards, Karol Bieniaszewski ... Od: "Scott Morgan"
Re: Using PSQL as a function? ... PSQL-based stored functions are implemented for V3, which is in Alpha state at the moment, thus not ready for production. For pre V3, you can use a
RES: [firebird-support] Re: database gone after server reboot It is only used in read only databases do decrease de size of a database for less space purpose. Do not use this in a production database, the overall
Fabiano - Desenvolvimento SCI
View First Topic Go to
Loading 1 - 30 of total 124,390 messages