The DB indexes for the farcry install appear to be unset - not using clustered indexes on certain columns etc... is there a reason for this? or is it a case of simply not working on these during development?
The problem lies with the fourq create scripts. We haven't gone through the exercise of working out how to set the indices for each supported database type.
This is really further complicated by the fact that we can't guess what columns people want to index (beyond say the core types) - so we need to extend the CFC property metadata as well.
For now, the recommendation is to simply implement the indices you believe are appropriate before you go into production.
-- geoff http://www.daemon.com.au/
--- You are currently subscribed to farcry-dev as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
