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 application is
its ability to address more RAM. Since fb_inet_server is taking so little
memory is there any point in installing 64 bit Firebird
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, MASTER_ID, VALUE1, VALUE2, VALUE3). The SELECT I want to get
would display all fields from MASTER and an aggregation of fields from
DETAIL, e.g.
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 bigint),
cast(right(S, 10) as bigint),
from (SELECT MASTER.ID,
(SELECT
lpad(SUM(VALUE1), 10) ||
lpad(MAX(VALUE2),
Hi Josef
W dniu 18.04.2014 10:49, Josef Kokeš pisze:
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, MASTER_ID, VALUE1, VALUE2, VALUE3). The SELECT I want to get
would display all fields
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
application is its ability to address more RAM. Since fb_inet_server is
taking so little memory is there any point in installing 64 bit
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 data if it helps
Hi!
Unfortunately, this is not applicable to my case, as I do have MASTERs
which have no DETAIL (yet).
Josef
On 18.4.2014 11:10, Thomas Beckmann wrote:
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 bigint),
cast(right(S, 10) as bigint),
from (SELECT MASTER.ID,
(SELECT
Josef
W dniu 18.04.2014 11:28, Josef Kokeš pisze:
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 data if it helps
Hi!
Unfortunately, this is not applicable to my case, as I do have MASTERs
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 applications just because 64 number is bigger than 32 = they
think that bigger means better.
But I have my own brain and thought that
On 18 Apr 2014 03:23:36 -0700, brucedickin...@wp.pl wrote:
Good guess! :-) However I am planning to change that, please take a look
if you do not mind and this post:
https://groups.yahoo.com/neo/groups/firebird-support/conversations/messages/124144
Someone did respond to that question, and as far as I can tell you didn't
follow up on it. I think it is very broad (too many different subjects and
questions in one post) and in general these questions are hard to answer as
there is no single solution when tuning.
Mark
How could I
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..
On 18 Apr 2014 03:52:30 -0700, brucedickin...@wp.pl wrote:
Thanks Mark! Could please give me your opinion on using 64 bit in
Classic
mode? Does it have sense?
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
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 Superserver.
Moreover it was version 2.5.1. As I read earlier there were some problems with
32 bit version 2.5.1 on machines with more than
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. Every time it tries to connect it gets gives the error:
SQL error in Database attach:
SQLCODE = -902 IN Database attach.
SQLCODE:
15 matches
Mail list logo