Hello! I use FB 2.5. I have a PC with 4 cores (I attach a link to an image of
the task manager).
https://www.five-oceans-images.com/articulos-web/1/Captura.JPG
https://www.five-oceans-images.com/articulos-web/1/Captura.JPG
When I run a query which takes about 15 minutes to run, I see
Thanks! Now I see why Dimitry said it was a problem of badly designed program.
I always try to be very carefull with transactions, but clearly I'm missing
something here.
The problem are the read/writte transactions, right? No problem with the read
only ones?
Is it possible to know
Hello!
I use FB 2.5,
The server has a 150 GB HD and it has 20 GB free.
My database is about 800MB in size.
Do you think having 20GB of free disk space may be a problem? I'm experiencing
a very bad performance lately and I can't figure out what can it be.
Database header page
Nope... :(
So, do you think that no database corruption can make this to happen?
I have two options here: the former... or I have a very hidden bug which I
didn't found yet which is deleting those missing records... just in case, I
created an "after delete" trigger to log any possible
Thanks Karol!!
The table "sto_depositos" (it means warehouses) is populated entering all the
warehouses manually. It barely changes. The "activo" field is used to hide some
warehouse I'm not longer using...
Sergio
Thanks for the answer!
> It depend how you table sto_depositos is populated and when you set activo=1?
The table is populated by this trigger, and the "activo" field doesn't change
(almost) ever!!! I'ts use only if I want to hide a warehouse that is not used
anymore...
Sergio.
Thanks!!!
> Have you checked if the trigger is still active, maybe it was disabled?
Yes I've checked it. The trigger is enabled and nobody disabled it before. I'm
the only one who changes such things...
> In the face of bugs or a corrupted database, of course anything is possible,
> but that
Hi Andras! well... I was sure (??) it wouldn't compile!! As a matter of fact
it was the first thing I tried! Obviously I had a typo somewhere and assumed
that the problem where with the "starting with" (and the typo wasn't "starts
with"... that was a mistake I did when I typed the question on
Hello! I know that there are a lot of different ways to accomplish this, but I
wonder if I'm missing something...
if I want (inside a stored proc or a trigger) to know if str1 starts with
str2, I can do:
if (position(str2 in str1) = 1) then...
but there isn't something like the
That's a very interesting solution as well Karol! Thanks!
I've just realized that I can "left join" my table against *any* table which I
know it already has enough records for my purpose
Thank you very much Mark and András!!!
I've tried András solution... I replaced (mechanically, without undestanding
too much what was going on...) and it did the trick perfectly!
Now is time to study a bit more and try to understand András answer :)
Thanks a million again!!!
Hello! is there any trick to select a fixed number of rows? I mean, no matter
if I have 2 rows which match the select, I need to always return 10 rows. Of
course the last 8 would be all null in this example...
I hope I'm clear with my question! Not sure if I'm in the "right path", but if
I
Thanks Dimitry! The same applies if the record wasn't deleted but changed by
another transaction? Because in this particular table there are no record
deletion. But a lot of blob fields editions all the time.
Sergio
Hello! I use Delphi XE2 / Firebird 2.5 / IBDAC 6.0.2
Since some days ago I'm getting (it seems very occasionally and randomly) a
"blob not found" error.
As far as I remember the problem happens during read operations: with "locate"
commands or inside a "while not eof" loop...
I don't
Hello Helen!!
THANKS A MILLION FOR YOUR VERY COMPLETE ANSWER
I did a simple routine to trap in a TXT log file all the active transactions.
I realized that I need to be SYSDBA in order to run a query against
MON$TRANSACTIONS. So, every time a user enters or exits from the applitaction
thanks Karol!
So, do you mean that the transactions numbers showed in the database header
indicate that I'm having long running read/write transactions somewhere?
NOTE: I've posted this question into "Firebird-general", but now I realize that
that group seems not to be active nowdays, so I post it here.
---
Hello! I'm noticing a small increase of my database size. Now it has 566,992
KB. After a backup/restore the size goes to 533,640 KB. I don't have
Thanks everybody for the inputs!!
Ann, You are right: space is no longer an issue these days... It's just that I
always keep asking whether is "the best" or the "correct" way to do it...
I'm not an expert in the matter, but I guess that having a field which in most
of cases will be null,
Hello! I have a FB 2.5 database with a tabla "invoices". I need to add a field
in that table which will be null most of the times. Lefts say, that 90% of the
records will have this new field in null.
What is your advice? To create a new table with a FK to "invoices" and save
the needed
hello! I've been googling but found nothing about it.
Why this sentence does not update all the records in the table? (FB 2.5)
update stock set actualizar = 0 where 1=1
Thanks!!
Sergio
sorry, I just copied a part of the select in the message. I do include that
flag in the actual select.
Here it is the complete select. I'm sending '-1' in "in_trans"
select
ma.mon$attachment_id,
mt.mon$transaction_id,
ma.mon$server_pid,
Hello! I'm having a problem which I don't undestand. I'm getting a deadlock
error in my app, but when I see the active transactions (I attach the select
I'm using) I see all read-only transactions active.
So, the question is: How can I get a deadlock error when I have just read-only
Hello! Generally speaking, regarding performance, is expensive having
calculated fields?
Not complex ones, I mean this type of thing:
... COMPUTED BY (cast(qty * price * tax / 100 as money 2))
So far I don't notice any difference but I'd like to hear opinions about
whether is a good
Hello! This is a bit of firebird.log (just the lines with errors) of the last
few days.
Thanks!!!
BARO (Client) Tue May 12 12:20:20 2015
C:\Program Files\Firebird\Firebird_2_5\bin\fbserver.exe: terminated
abnormally (4294967295)
BARO (Server) Tue May 12 12:30:24 2015
*** DUMP ***
Hello! I have a Delphi app with Firebird. Everything in a single PC which is
accesed via Remote Desktop by 5 or 6 users.
It worked fine for much years. But since yesterday, My app reports an error of
conection lost. I'm used to see this error when working on a local network
and some PC lost
Hello! I have a customers table. I created some calculated fields in order to
have the complete name of each customer in a single column. I attach the field
definitions below. I don't know whether my calculated fields are complex or
not to Firebird!
I'm testing with aprox 40.000 rows
Hello, using FB 2.5 is there an easy way to get the workings days between to
dates? Or should I do an UDF for that?
Thanks!!
Hi Tomas! I just mean week days...
Something like DateDiff() but only counting from monday to friday.
I have a function in Delphi for that. I could make an UDF I think. I just
wander if there is something already done. I thought it was something very
used... probably is not?
Hi Tomas! I just mean week days...
Something like DateDiff() but only counting from monday to friday.
I have a function in Delphi for that. I could make an UDF I think. I just
wander if there is something already done. I thought it was something very
used... probably is not?
(FB 2.5)
Hello! I have some temp tables in order to select records. Like this:
CREATE GLOBAL TEMPORARY TABLE SEL_STO (
ID INTEGER NOT NULL
) ON COMMIT DELETE ROWS;
ALTER TABLE SEL_STO ADD CONSTRAINT PK_SEL_STO PRIMARY KEY (ID);
My question is: it makes sense having a PK in this table? The
Hello Arnold! I'm afraid I don't understand how your answer is related to my
question. Sorry about that! Could you explain a bit more, please? I'm
interested in learn different options!
Are you talking about Firebird, or something else?
Thank you very much to everybody!!!
Hello, I've posted this question in the general but the moderator told me
it's a support question. So here I go again!
It's a design / normalization question: How to save Invoice detail correctly?
Each line on the invoice detail has its FK pointing to the Article's ID, but
sometimes the user
32 matches
Mail list logo