Ann, thanks you so much for such good explanation !
can not wait more for the V3, hope soom the first beta will be ready
On Fri, 30 Mar 2012 06:40:39 -, "nathanelrick"
wrote:
> http://www.addsimplicity.com/downloads/eBaySDForum2006-11-29.pdf
>
> No business logic in database
> no stored procedure
> only very simple triggers (default population)
>
> Move CPU intensive work to applications
> Referential integr
> I think you also mentioned that Ebay doesn't allow joins and uses the
> application to do the joining. If that's the case, I'm glad I don't work
> for Ebay. I'll be willing to bet that the Ebay application is written in
> Java - that sounds like the sort of thing that the Java developers (and
Perfect
1 million of thanks
=
|| ISMAEL ||
=
- Original Message -
From: Huan Ruan
To: firebird-support@yahoogroups.com
Sent: Thursday, March 29, 2012 5:13 PM
Subject: Re: [firebird-support] Arithmetic overflow or division by zero has
occurred.
On 30 M
On 30 March 2012 03:21, Ismael L. Donis Garcia wrote:
> **
>
>
> 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,9451
On 29/03/2012 14:25, jakefeed wrote:
>
> We have an database in which we supply product catalogs with pricing.
> The end user can create their own items, too. In order to separate the
> user's items from the items we supply, we're contemplating using
> negative primary keys for our items and pos
> We have an database in which we supply product catalogs with pricing. The
> end user can create their own items, too. In order to separate the user's
> items from the items we supply, we're contemplating using negative primary
> keys for our items and positive primary keys for the users items
On Thu, Mar 29, 2012 at 9:25 AM, jakefeed wrote:
> We have an database in which we supply product catalogs with pricing. The
> end user can create their own items, too. In order to separate the user's
> items from the items we supply, we're contemplating using negative primary
> keys for our ite
We have an database in which we supply product catalogs with pricing. The end
user can create their own items, too. In order to separate the user's items
from the items we supply, we're contemplating using negative primary keys for
our items and positive primary keys for the users items. We ar
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 ||
=
- Ori
2012/3/29 Josef Koke¹
>
> Due to hardware malfunction, my database got damaged. GFIX (-v -f -i)
> tells me that a database has 1 "record level error", 9 "data page
> errors", 41 "index page errors" and 322 "database page errors".
>
IBFirstAid is your friend, as is backup. But before you backup
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 soluti
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)
>
Hi!
Due to hardware malfunction, my database got damaged. GFIX (-v -f -i)
tells me that a database has 1 "record level error", 9 "data page
errors", 41 "index page errors" and 322 "database page errors".
I am not concerned about Index page errors - is seems obvious these will
get fixed by a ba
Morning Thomas,
> Partitioning in Oracle is top-notch, definitely. Using that in a project
> as well, but needless to say, it's pricey, as you need Enterprise and
> partitioning is an additional option you have to pay separately.
This much is true, and unfortunate. I think Oracle work on the princ
>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
cast(1/0.
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
17 matches
Mail list logo