How do you find area in area?
Are you storing polygon data in blob, then parse it via STORED PROCEDURE in
P-SQL and then test for overlapping?
It is probably doable but not very convenient and a lot slower then built in
solution would be.
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
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
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..
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
Awesome, thanks.
Hi guys,
I have problems which I can not explain, nor do I know how to solve it.
We have FB 2.5.2 classic on linux. We have like 60 Databases there.
From time to time, we can not connect to few of the databases. Simply, when we
try to connect, a connection process is hanging (regardles of
Thank you,
I have about 800 connections and limit is set up on 3...
jimi_compot thanks for the suggestion. Does automatic sweep causes of spawning
another fb_inet_server process?
Because I have a lot of processes that I am not able to identify. I''ve checked
all my databases and could not find those processes in system tables.
Hello guys,
I am asking you kindly for helping me in tuning our Firebird 2.5 which is
installed on Linux. Our admin says that Firebird is eating to much CPU.
Here are the details regarding our server which is dedicated for Firebird:
24 GB RAM, 20 GB free (according to free command under Linux)
Hi guys.
We are thinking (and thinking and thinking and thinking...) about converting
our database to UTF8. The thing is that we have some columns that we would like
to keep as ANSI columns, the reasons for that are:
1. We want to save some space, we have VARCHAR(300) column, after switching
So, for what it is worth I've made a follow up comment here:
https://groups.yahoo.com/neo/groups/Firebird-general/conversations/topics/9
Regards.
Hello guys,
I have atleast one database on which this problem occurs when I try to backup
the database. I do not know what caused this problem. Is it possible to cause
this problem by executing DDL/DML statements?
On this page: http://ibsurgeon.com/articles/item69; the reason for this
problem
Thank you for your response.
The nature of errors is the following - one of record's backversions is
missing, and Firebird cannot read chain of back versions to build actual
(yours) version of this record.
The reason wrong transaction management, I think, is not correct, and we
will change
You should check wich application holds the oldest transaction open, and fix
it.
Thank you, is it possible that this transaction is just hanging and an
application which started it,has been already terminated? If I am not mistaken,
I can somehow check out some system table for active
Do you know if or when the trigger was ACTIVATED? It's very hard to see how
deactivating a hungry trigger like that one could *degrade* performance.
I am sorry Helen for confusing you. I've posted DDL for already deactivated
trigger which I've deactivated yesterday.
The trigger was
Hi guys.
I have one table that currently has 100 000 000 records. PageSize is 16384.
Index statistics for primary key are 0.00 (I've recomputed them).
Over a few days inserting and updating this table slowed down significantly.
When I try to update one row:
UPDATE TABLE SET VALUE=X WHERE
Thanks a lot,
I will post that info tommorow.
Regards.
Hello,
take a look at this example UDF declaration:
DECLARE EXTERNAL FUNCTION F_BLOBLOAD
CSTRING(8191),
BLOB
RETURNS PARAMETER 2
ENTRY_POINT 'blob_load' MODULE_NAME 'FAUfile';
I can compile and save this function even when there is NO FAUfile.dll
physically on the disk. I will
I will take a lok at this option, thank you.
What firebird version?
Firebird 2.5.1 Classic, on Linux.
How many indices has that table?
22 :(
Do you update indexed fields?
Partially
May be the problem is Firebird performance with large indices.
But you know, few days ago performance was good. I had not changed anything
since 2
Hi guys.
I've already posted this question but it has not shown up on the group, so I am
sorry if it appears duplicated later.
My case is probably hopeless but I thought I'd ask anyway.
As you know, it is possbile to declare UDF without dll present in the required
path. For example:
DECLARE
Regarding the number of pages.
Correct me if I am wrong (http://www.firebirdsql.org/manual/gfix-buffers.html)
but if Superserver is using 2048 pages and page size is 16384, than computer
must have 32 GB RAM installed. What is happening when there is less RAM
installed?
.
---In firebird-support@yahoogroups.com, iblist@... wrote:
Em 15/1/2014 16:30, brucedickinson@... mailto:brucedickinson@... escreveu:
Hi guys.
I have one table that currently has 100 000 000 records. PageSize is 16384.
Index statistics for primary key are 0.00 (I've recomputed them
One thing I do not understand. If the trigger has been installend over two
months ago, why performance degraded just few days ago and not immediatelly
after the trigger has been activated?
Hi guys,
I have a DB column with NONE charset and it contains characters from WIN-1250
charset. Now, I would like to change character set of this column to UTF8.
I've read below topic in order to do this:
http://groups.yahoo.com/neo/groups/firebird-support/conversations/topics/100023
The
Hi guys,
have anyone tried these functions? I can save and load ascii named blobs to
disk but it does not work for unicode paths. For example:
SELECT F_BLOBLOAD('E:\你好.txt') FROM RDB$DATABASE gives me an empty blob.
I can not test it via FlameRobin because it is not able to properly create a
Hello,
I guess the topic says all. Can I somehow detect where (on what operatin
system) the Firebird server is placed?
Regards.
Mark, thank you very much. I've lost hope that somebody answer this.
---In firebird-support@yahoogroups.com, mark@... wrote:
On 23-11-2013 19:25, brucedickinson@... mailto:brucedickinson@... wrote:
Hi guys.
I am thinking about writing an UDF function. This function needs to know
Hi guys.
I am thinking about writing an UDF function. This function needs to know the
path to database regardless of the operating system. So it needs to know the
path to database in Linux and Windows as well.
I have no idea how to get programatically (in PSQL) path to a database. A
context
, 2013 at 5:22 AM, brucedickinson@... mailto:brucedickinson@...
wrote:
Hi guys,
I have this strange problem which I do not get it. I am trying to check my
database with given options:
gfix -user SYSDBA -password masterkey -v MYBASE.FDB
and.. nothing, no return info. Nothing.
When I
Hi guys,
I have this strange problem which I do not get it. I am trying to check my
database with given options:
gfix -user SYSDBA -password masterkey -v MYBASE.FDB
and.. nothing, no return info. Nothing.
When I intentionally give non existant file, like this:
gfix -user SYSDBA -password
33 matches
Mail list logo