Hi all,
I have Superserver Firebird 2.5.1 installed on Win7 pro 64 bit on I7 2600K.
When data grows, Firebird Server starting to slow down. I shutdown Firebird
Server, starting again without changing anything and Firebird Server became
smooth again.
Any ideas, what is the problem with this?
El 15/07/2013, a las 16:31, trskopo trsk...@yahoo.com escribió:
Hi all,
I have Superserver Firebird 2.5.1 installed on Win7 pro 64 bit on I7 2600K.
When data grows, Firebird Server starting to slow down. I shutdown Firebird
Server, starting again without changing anything and Firebird
--- In firebird-support@yahoogroups.com, Jesús GarcÃa jegaza@... wrote:
El 15/07/2013, a las 16:31, trskopo trskopo@... escribió:
Hi all,
I have Superserver Firebird 2.5.1 installed on Win7 pro 64 bit on I7 2600K.
When data grows, Firebird Server starting to slow down. I
What are you seeing that makes you think your goal has not already been met?
On Mon, Jul 15, 2013 at 12:38 PM, trskopo trsk...@yahoo.com wrote:
Hi all,
I have a 16GB RAM and since my database file is small size, it can
completely runs on RAM.
The problem is I can not set FB SuperClasic
Just increase Page Buffers
[Non-text portions of this message have been removed]
El 15/07/2013, a las 18:23, trskopo trsk...@yahoo.com escribió:
--- In firebird-support@yahoogroups.com, Jesús García jegaza@... wrote:
El 15/07/2013, a las 16:31, trskopo trskopo@... escribió:
Hi all,
I have Superserver Firebird 2.5.1 installed on Win7 pro 64 bit on I7
On Mon, Jul 15, 2013 at 12:54 PM, trskopo trsk...@yahoo.com wrote:
Simple, i still have a lot of free RAM.
As Sean pointed out, that suggests you may not have achieved your goal but
does not definitely indicate that you haven't.
Better indication would be file I/O that you would not expect.
Delphi XE, FB 2.5
I need to make an array of values from database columns (much like a crosstab)
that can be attached to a data source. In my particular case, one database
column holds the names of samples sent for analysis, one holds the names of the
compounds, and a third hold the reported
I will use them in a GIS application or for charting to plot one compound
against another, or to show pie charts in the GIS app
--- In firebird-support@yahoogroups.com, Leyne, Sean Sean@... wrote:
Delphi XE, FB 2.5
I need to make an array of values from database columns (much like a
Thanks for all replays.
I did a small test, here are the settings :
- FB Super Classic 2.5.1 64 bit
- Win7 pro 64 bit
- Database size about 640mb
- Select something like this :
select a.field1, b.field2, sum(c.field3)
from table1 a, table2 b, table3 c
where
group by
-
Thanks for all replays.
I did a small test, here are the settings :
- FB Super Classic 2.5.1 64 bit
- Win7 pro 64 bit
- Database size about 640mb
- Select something like this :
select a.field1, b.field2, sum(c.field3)
from table1 a, table2 b, table3 c
where
group by
- temp directory set
Hi all,
I have a table that always contains 1 record and have about 50 fields with
various type. It's function is to store system parameters and is accessed very
frequent from application and also from database triggers and stored
procedures. Is it wise to utilize a singleton table like this,
Em 16/7/2013 00:03, thp_pkmi escreveu:
Hi all,
I have a table that always contains 1 record and have about 50 fields with
various type. It's function is to store system parameters and is accessed
very frequent from application and also from database triggers and stored
procedures. Is it
Em 15/7/2013 21:55, Craig Cox escreveu:
I will use them in a GIS application or for charting to plot one compound
against another, or to show pie charts in the GIS app
I prefer to create the cross tab on the client side...
I think I have much more control over it...
see you !
Thank you Alexandre for your reply. Furthermore, is it any difference accessing
that singleton table by:
SELECT .. INTO .. FROM SINGLETON_TABLE
or
SELECT .. INTO .. FROM SINGLETON_TABLE ROWS 1
Regards,
Tjioe
--- In firebird-support@yahoogroups.com, Alexandre Benson Smith iblist@...
wrote:
Em 16/7/2013 01:37, thp_pkmi escreveu:
Thank you Alexandre for your reply. Furthermore, is it any difference
accessing that singleton table by:
SELECT .. INTO .. FROM SINGLETON_TABLE
or
SELECT .. INTO .. FROM SINGLETON_TABLE ROWS 1
Regards,
Tjioe
There is no way a query in a table with
16 matches
Mail list logo