[
https://issues.apache.org/jira/browse/DAYTRADER-25?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Christopher James Blythe reassigned DAYTRADER-25:
-------------------------------------------------
Assignee: Christopher James Blythe
> Update decimal precision and indexes in ddl
> -------------------------------------------
>
> Key: DAYTRADER-25
> URL: https://issues.apache.org/jira/browse/DAYTRADER-25
> Project: DayTrader
> Issue Type: Improvement
> Reporter: Christopher James Blythe
> Assigned To: Christopher James Blythe
> Priority: Minor
> 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 conversion.
> 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.
