> The way I understood it, is each 32 bit process running on 64 bit
> windows can access a max of 2 gig each. So if you are running 3 memory
> intensive 32 bit applications they each be able to access a max of 2
> gig, utilising a total of 6 gig?
Correct.
With my selection of applications, I pref
> 1) Why do you group on something not an output field? I didn't think
> that was allowed.
It is. I am not sure if it has any reasonable use, but it is possible.
> 2) LEFT JOIN followed by referencing to a field in the table being NOT
> NULL makes the LEFT JOIN in reality become a (inner) JOIN, s
>>PS. if there are brand new machines, I'd put 64 bit windows on, then run 32
>>bit applications. That way your PC can utilise more memory.
>Unfortunately not. A 32-bit application can't use more than 4GB, regardless
>of how much RAM the 64-bit machine has.
The way I understood it, is each 32
>I have a query with an aggregate function (AVG) that I believe is the cause
>for the very slow
>execution times on the the first instance. The first execution will take
>around 2.5 minutes and
>subsequent queries will take around 6 seconds. I am using FB 2.5.2 in
>SuperServer mode with a
>pa
At 05:35 p.m. 5/02/2013, Maya Opperman wrote:
>PS. if there are brand new machines, I'd put 64 bit windows on, then run 32
>bit applications. That way your PC can utilise more memory.
Unfortunately not. A 32-bit application can't use more than 4GB, regardless
of how much RAM the 64-bit machin
When trying to save a row I get the message:
"arithmetic exception, numeric overflow, or string truncation"
"string right truncation"
And?
The table has several column. Which is the problematic one?
I should revise one for one??
Greetings.
Walter.
[Non-text portions of this message have
Just an extra point,
is there any firebird/sql command to check how much disk/memory the
database/server is using or just from filesystem/process perspective ? (ls or
ps -o rss,vsz)
Thanks.
Julien
If you connect on the server to localhost, is there still a problem?
Are you using a GDB or FDB files extension. GDB has issues.
Also, check you just have one instance of Firebird/Interbase running.
Make sure your network cables are the right ones for your network's speed.
Make sure your anti-
Thank-you that seems to have done the trick :)
That has saved me hours of worry and it has also improved my app stock
control function
Andy
-Original Message-
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Ismael L. Donis
Garcia
Sent: 04 Feb
Ann Harrison wrote:
> > That works - if the difference between 1.0 and 1.5.6 doesn't matter to you
> > - but the OP wanted a solution that didn't require opening a database
> > connection first (and as we now know, he needs it for JDBC).
> That's a little like wanting to know the color of your pr
On Sun, Feb 3, 2013 at 7:25 PM, Paul Vinkenoog wrote:
>
>
> That works - if the difference between 1.0 and 1.5.6 doesn't matter to you
> - but the OP wanted a solution that didn't require opening a database
> connection first (and as we now know, he needs it for JDBC).
>
>
That's a little like wa
I have a query with an aggregate function (AVG) that I believe is the cause for
the very slow execution times on the the first instance. The first execution
will take around 2.5 minutes and subsequent queries will take around 6 seconds.
I am using FB 2.5.2 in SuperServer mode with a page size of
Hello,
You could also do:
1. Disable all triggers and procedures. IBExpert lets you do it all at once
(Desactivate ALL Triggers/Store Procedures).
2. Delete or rename the UDF
2. Backup and Restore the DB.
3. Activate one by one and trigger procedures.
Regards.
PD: Sorry for my English :)
[No
> I'm working on the migration of a FB1.5 database to FB2.1.
> In my FB1.5 database i used an udf "trim", but in fb2.1 trim is an FB internal
> function.
Note to all, for future reference, do not use UDF names which *could* conflict
with internal functions that may be added. For myself, to ens
Hello,
I'm working on the migration of a FB1.5 database to FB2.1.
In my FB1.5 database i used an udf "trim", but in fb2.1 trim is an FB internal
function.
I want to use the internal function and remove the udf.
I'm tryin to drop trim udf like this :
DROP EXTERNAL FUNCTION "TRIM"
But it does'nt
Hi,
I already tried using host name and ip address. There is no difference.
Thanks,
Luiz
De: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] Em nome de Leyne, Sean
Enviada em: segunda-feira, 4 de fevereiro de 2013 18:13
Para: firebird-support@yahoogroups.
> I already did it. I disabled windows firewall in these machines. The problem
> was not solved.
>
>
> Luiz
>
> De: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] Em nome de Leyne, Sean
> Enviada em: segunda-feira, 4 de fevereiro de 2013 17:13
> Para: firebird-sup
Hi, Sean,
I already did it. I disabled windows firewall in these machines. The problem
was not solved.
Att,
Luiz
De: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] Em nome de Leyne, Sean
Enviada em: segunda-feira, 4 de fevereiro de 2013 17:13
Para: fir
Luiz,
> I just bought other 2(two) new machines. It´s a Dell optiplex 3010, with
> windows 7 Pro 32 bits, 4GB RAM.
>
> I installed firebird client 1.56 in that machines.
>
> When I try connect to database from these new machines, it takes a long
> time and the queries also are very slow.
>
> I
Hi,
First, excuse-me if this is not the correct forum to post it.
I have a SERVER running firebird SS 1.56 with 9 PC clients, all using
windows XP without slow connection on first connection or executing queries.
I just bought other 2(two) new machines. It´s a Dell optiplex 3010, with
windows
Replace
SQLCommand = SQLCommand & "CURRENTLEVELS = CURRENTLEVELS - '" &
Format(Readin(3), "#0") & "' "
for
SQLCommand = SQLCommand & "CURRENTLEVELS = CURRENTLEVELS -" & Format(Readin(3),
"#0")
Best Regards
=
|| ISMAEL ||
=
- Original Message -
From: Andy
>Hi,
>
>CURRENTLEVELS is set as a integer
>BARCODENUMBER is set as a VarChar(13) as that is the max number of a barcode
>STOCKCONTROLYN is set to >VarChar(1) as it is is either 1 or 0
>
>And yes
>
>UPDATE ProductTable
>SET CurrentLevels = CurrentLevels - ''
>WHERE BarcodeNumber = ''
> AND StockCo
Hi,
CURRENTLEVELS is set as a integer
BARCODENUMBER is set as a VarChar(13) as that is the max number of a barcode
STOCKCONTROLYN is set to VarChar(1) as it is is either 1 or 0
And yes
UPDATE ProductTable
SET CurrentLevels = CurrentLevels - ''
WHERE BarcodeNumber = ''
AND StockControlYN = '1'
>I am trying to update a coloum in Firebird via the following SQL command
>
>SQLCommand = vbNullString
>SQLCommand = SQLCommand & "UPDATE ProductTable "
>SQLCommand = SQLCommand & "SET "
>SQLCommand = SQLCommand & "CURRENTLEVELS = CURRENTLEVELS - '" &
>Format(Readin(3), "#0") & "' "
>
>SQLComm
Hi all
I am trying to update a coloum in Firebird via the following SQL command
SQLCommand = vbNullString
SQLCommand = SQLCommand & "UPDATE ProductTable "
SQLCommand = SQLCommand & "SET "
SQLCommand = SQLCommand & "CURRENTLEVELS = CURRENTLEVELS - '" &
Format(Readin(3), "#0") & "' "
SQ
> My opinion is simple. If
> Firebird DB at disk, attached not to RAID - fast
> and
> Firebird DB at dis, attached to the RAID - slow
> then problem is with raid controller configuration.
> "Other applications" can use disk less then Firebird, or
> only read, so, the IO of that applications can be
Emil wrote:
> It might help others if a note is inserted somewhere in the documentation,
> that for the RETURNING clause to work correctly for updatable views with
> generated, default or computed fields, the respective NEW variables must be
> explicitly assigned.
Good point. I'll put that in
On Mon, 04 Feb 2013 08:09:44 +0800, Wolfgang Kluge
wrote:
> Good morning Paul
>
> I am using
>
> Try
>
>Qry.Close;
>Qry.SQL.Text := 'select rdb$get_context(''SYSTEM'',
> ''ENGINE_VERSION'') cVer from rdb$database'; // fails on engine version
<
> 2
>Qry.ExecQuery;
>
28 matches
Mail list logo