MySQL 5.
Which would be the better choice for a report table. I'm concerned and want the
query to run as fast as possible because there could end up being millions of
records in it.
I could add the number of fields I need (not worried about the flattening of
this table and lack of normalization). Instructor1, instructor2, 3, 4, etc.
Then query like this:
AND (e2.instructor1id =
<cfqueryparam value="#ARGUMENTS.instructor#">
OR e2.instructor2id =
<cfqueryparam value="#ARGUMENTS.instructor#">
OR e2.instructor3id =
<cfqueryparam value="#ARGUMENTS.instructor#">
)
OR ... I could easily create a list of values, then use the IN keyword:
AND someotherfield IN (<cfqueryparam value="#ARGUMENTS.somevaluelist#"
list="yes">)
Thanks,
Will
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion is delivering applications solutions at at top companies
around the world in government. Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291685
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4