[ http://issues.apache.org/jira/browse/DAYTRADER-25?page=all ]
Christopher James Blythe updated DAYTRADER-25:
----------------------------------------------
Attachment: daytrader-25.schema.patch
Here is a patch to fix the schema files associated with DT-14 (built against
the 1.2 branch).
This updates the indexes and the decimal precision.
> Update decimal precision and indexes in ddl
> -------------------------------------------
>
> Key: DAYTRADER-25
> URL: http://issues.apache.org/jira/browse/DAYTRADER-25
> Project: DayTrader
> Issue Type: Improvement
> Reporter: Christopher James Blythe
> Priority: Minor
> Attachments: 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.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
