Having said that, the way it works is slightly inefficient, in 2 ways. The first is that the query on line 155 should really just select count(*) from #application.dbowner#dmNews, instead of return all of the rows.
The second is that the main queries should only return stObj.numItems rows,
with relevant offset / limit, rather than return 'maximumRows' rows. Or if
that syntax isn't easily supported in oracle, then just use it where
possible (e.g. mysql)
I agree with you here Quentin. There is a lot of optimisation opportunities throughout the entire code base, so if anyone out there has better ways of doing things, please let us know. A lot of this code is legacy stuff and has just been plugged in and made to work with FarCry. Once we have a stable build and the core functionality as we would like it, we will begin the process of optimsation. Paul and I actually took a quick look at some of the display code last week and it's now running about 100% faster...I'm sure there are improvements that can be made like this all over the place.
-Brendan http://farcry.daemon.com.au
--- You are currently subscribed to farcry-dev as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
