Efficiency question

[PlastechFish]

I am writing an SQL statement to display the most recent articles posted into a
database. I know that I can specify the max rows and use "order by desc" but
it seems like the database would have to return all the data and then the
coldfusion server would crop and order it. Is there a more efficient way to do
this? In otherwords can I have the database return only a specified number of
entries? Thank you for your help.

Always in awe,
Plastech

[The ScareCrow]

You can either use

Select Top 50 column1, column2

Which will return the top 50 records

Or you could return records that are between certain dates

Select column1, column2
From myTable
Where myDateColumn Between #CreateODBCDate(Now())# And
#CreateODBCDate(DateAdd("d", -7, Now())#

Which will return all records that have a date that is between now and 7 days
ago

Ken

[Richard.B]

Hi guys....

Just a quick couple of questions;

1. If i use the inker modifier on a group of models in my scene...will the
performance take a noticable hit?
2. Does using removefromworld and addtoworld to take away any models that
aren't needed or seen at the time have any
marked effect on the speed/efficiency of my game?

The game that i am making at the moment isn't going online....so i don't have
to be quite as tough on file size, but i still want my game to run smoothly on
other computers.

Thanks in advance

Richard

[Michaelcov]

I cannot answer no.1 but the second, using remove/add, works fine without any slowdowns but you will notice a delay when you addToWorld a model for the first time.

Cheers,

Michael
UK