Hi Norman,
yes i understand, but now with my 50 millions rows table i start to meet the
limit of firebird where a simple prepare can take around 1 s to 1 min
dependantly the charge of the server (see my previous post). next year it's
will be around 100 millions rows and i will have no
SELECT cast((5411.000455/0.20) as numeric(16,6)) as mount FROM
MON$ATTACHMENTS r
This particular query can be rewritten as
SELECT 5411.000455*cast(1/0.20 as integer) as mount FROM MON$ATTACHMENTS r
Though it will not work equally well with other numbers, at least not if
Hello Josef,
Look into firebird.log - there should be information about corrupted
record/table.
You can also check your database with FBFirstAID Diagnostician.
Regards,
Alexey Kovyazin
IBSurgeon (www.ib-aid.com)
Hi!
Due to hardware malfunction, my database got damaged. GFIX (-v -f -i)
Norm,
yes i understand, but now with my 50 millions rows table i start to meet
the limit of firebird where a simple prepare can take around 1 s to 1 min
dependantly the charge of the server (see my previous post). next year it's
will be around 100 millions rows and i will have no solutions
That operation does not give the precision that I need ( 6 digits after decimal
point )
SELECT 54311.999455*cast((1/1.01) as integer) as mount FROM MON$ATTACHMENTS
r = 54311.999455
54311.999455 / 1.01 = 54311,945143
Thank you for everything
=
|| ISMAEL ||
=
-