geronimo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Christopher James Blythe (JIRA)" <>
Subject [jira] Closed: (DAYTRADER-25) Update decimal precision and indexes in ddl
Date Mon, 19 Feb 2007 18:14:05 GMT


Christopher James Blythe closed DAYTRADER-25.

       Resolution: Fixed
    Fix Version/s: 2.0

Applied code and schema patches to branches/1.2 and trunk.

> Update decimal precision and indexes in ddl
> -------------------------------------------
>                 Key: DAYTRADER-25
>                 URL:
>             Project: DayTrader
>          Issue Type: Improvement
>            Reporter: Christopher James Blythe
>         Assigned To: Christopher James Blythe
>            Priority: Minor
>             Fix For: 1.2, 2.0
>         Attachments: daytrader-25.code.patch, daytrader-25.schema.patch
> While working with previous versions of Trade, I found that the monetary values stored
in the database could overrun the decimal precision defined in the schema (10,2) if allowed
to run for an extended period of time. This would result in SQL exceptions related to data
> To prevent this we increased the decimal presion to (14,2)
> We also found that some of the indexs were not necessary and that others should be added.
> In addition to the primary keys, here are the indexes we found to be the most useful...
> CREATE INDEX a.profile_userid on accountejb(profile_userid);
> CREATE INDEX h.account_accountid on holdingejb(account_accountid);
> CREATE INDEX o.account_accountid on orderejb(account_accountid);
> CREATE INDEX o.holding_holdingid on orderejb(holding_holdingid);
> CREATE INDEX o.closed_orders on orderejb(account_accountid,orderstatus);
> Will wait to submit a patch until the fate of Daytrader-14 is determined.

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message