Message received. I'll go away
Hi Homer, hope you haven’t gone completely away just yet. Your question (and
problem) may be off-topic for this list, but I'll try to keep my answer more or
less on-topic.
Your SQL puzzles me, I've never before seen 'select distinct Sum(' in a
subselect, and
I wrote:
WITH MyParam(Param) as
(SELECT CAST(:MyInput AS SMALLINT) FROM RDB$DATABASE),
Tmp(PolNum, Transdate, Sum_Of_ArAmt) AS
(SELECT PolNum, Transdate, sum(ArAmt)
FROM AR
WHERE ArAmt 0
GROUP BY 1, 2)
SELECT M.CARRIERNO, M.CARRIER, M.POLNUM, M.INVOICENO, M.TRANSNO, M.TRANSDATE,
Hi Alexey,
For the database (Using GBAK restore with options):
Page Size = 8192
Buffers = 1
In the firebird.conf file:
DefaultDBCachePages = 32768
Is this okay?
Bests,
Steve
Change your fb to Classic or Superclassic so you can use all cpu cores.
If you choose Classic you also need to increase hashmemslots by 10 times at
least (prime number). Google for it.
Em 08/01/2014 22:39, stevef...@yahoo.com escreveu:
Hi,
I'm running Firebird 2.5.2 SuperServer on a Windows
Yes.
Em 09/01/2014 04:56, dice_in_trou...@yahoo.com escreveu:
Hi all, is it possible to transfer the content of a table to a new one?
Thanks,
column numbers and type must match in inserted table from the select
insert into Members (number, name)
select number, name from NewMembers
I have stumbled upon a problem with Selects based on indices which do not seem
to be updated as they should.
There are no Active Transaction but there are more reads than the actual number
of records corresponding to my select conditions.
Here's an example :
create table Test1(id1 integer not
Hello, Evelyne!
Thursday, January 9, 2014, 8:57:13 PM, you wrote:
EG The problem is that the index seems to keep having old values
EG until there is not a single connection to the database (even if I
EG commit every transaction). This causes me real performance
EG problems on 24/7 systems ...
Hi Steve,
Value from database header overrides default value from conf file.
So I believe this is Ok.
Regards,
Alexey Kovyazin
IBSurgeon
Hi Alexey,
For the database (Using GBAK restore with options):
Page Size = 8192
Buffers = 1
In the firebird.conf file:
DefaultDBCachePages = 32768
Thanks a lot for your answer Dimitry,
your problem is versions, because index keep all keys for all
versions. If you have active transactions, garbage collection
does not work, and obsolete keys and versions are not cleaned.
Check gstat -r to see how many versions tables have when you have
Thank you, Svein. I like the param idea. As you might be able to tell, this
piece of the project is still under development. Now is a perfect time for me
to switch to parameters.
I solved my problem late last night. It was not easy to isolate. I usually set
break-points and step through the
Test.
I am not receiving the messages that I send to the list
Best Regards
| ISMAEL |
12 matches
Mail list logo