Loading ...
Sorry, an error occurred while loading the content.
124390
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
Thomas Steinmaurer
6:12 AM
#124390
 
124389
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
Thomas Steinmaurer
6:07 AM
#124389
 
124388
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
un_spoken
5:55 AM
#124388
 
Fetching Sponsored Content...
124387
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
jimi_compot
5:22 AM
#124387
 
124386
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
Mark Rotteveel
4:05 AM
#124386
 
124385
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..
un_spoken
3:57 AM
#124385
 
124384
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
un_spoken
3:52 AM
#124384
 
124383
Re: Is there any benefit when using Firebird Classic in 64bit versio ... https://groups.yahoo.com/neo/groups/firebird-support/conversations/messages/124144 ...
Mark Rotteveel
3:44 AM
#124383
 
124382
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
un_spoken
3:23 AM
#124382
 
124381
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
Marcin Bury
2:33 AM
#124381
 
124380
Re: Efficient subselects ... Interesting approach. I will consider it, maybe it would be sufficient for my needs. Thanks! Josef
Josef Kokeš
2:29 AM
#124380
 
124379
Re: Efficient subselects ... Hi! Unfortunately, this is not applicable to my case, as I do have MASTERs which have no DETAIL (yet). Josef
Josef Kokeš
2:29 AM
#124379
 
124378
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
Thomas Steinmaurer
2:21 AM
#124378
 
124377
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
Marcin Bury
2:17 AM
#124377
 
124376
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
Thomas Beckmann
2:10 AM
#124376
 
Fetching Sponsored Content...
124375
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,
Josef Kokeš
1:50 AM
#124375
 
124374
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
un_spoken
Apr 17
#124374
 
124373
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
Lee Graber
Apr 17
#124373
 
124372
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
Helen Borrie
Apr 17
#124372
 
124371
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.
Ted Miglautsch
Apr 17
#124371
 
124370
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.
Ted Miglautsch
Apr 17
#124370
 
124369
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
Mark Rotteveel
Apr 17
#124369
 
124368
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
Lee Graber
Apr 17
#124368
 
124367
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
Helen Borrie
Apr 17
#124367
 
124366
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
Thomas Steinmaurer
Apr 17
#124366
 
124365
Re: Using PSQL as a function? ... Ah, even more to look forward to with v3. ... Thanks, that makes sense. Scott
Scott Morgan
Apr 17
#124365
 
124364
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
Leyne, Sean
Apr 17
#124364
 
Fetching Sponsored Content...
124363
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"
liviuslivius@...
Apr 17
#124363
 
124362
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
Thomas Steinmaurer
Apr 17
#124362
 
124361
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
Apr 17
#124361
 
View First Topic Go to View Last Topic
Loading 1 - 30 of total 124,390 messages