Re: Select query with GROUP condition thens order by alphanumeric

[Chu Soon Tan]

Chad Bourque Wrote:
-------------------------------------------------------
> chusoon,
>
> Like I said, if you need this sorting and still
> want the speed, create an additional column that
> gets updated via triggers (insert and update). The
> function would be plenty fast enough to not slow
> down an insert or update (unless you are updating
> the whole table at once). Then, your sorting would
> be instantaneous.
>
> HTH,
> Chad

Chad, get your ideas....but the problems if the data was updated by user frequency (data entry by user)....... then i need to restructure every time user input the data(delete and insert to new table). It may be quite high processing to the database.

for example: data input 20 time per day(from diff user), then need to be restructure every time after user date entry. And it was not problems when the data is less but it going to be a problems if the data become more and more huge (10K, 50k, n etc)

thanks chad.

chusoon