>Hi,
>
>I appreciate many of guys here and allways use useful advices, hints and chunk of codes including yours and I thankfull for all that to all. There were also many "bizzar" and peculiar wishes and requests here. Now, I am wondering if my was one the worst !?

Hi Gojko

I was only trying to get your attention. Smart people sometimes do stupid things. That does not mean they are stupid. :)

What you're trying to do is reasonable. Having an ability to organize records in a list is very necessary. You do not have to physically organize the records to make it look like they are sorted. This may be working for you in your limited perspective. I tend to think in bigger terms than that.

What is a way that will work to organize records so that you can handle 10 records or 10 million?

You add a field to control the order of the records. You add indexes to the table to let the user extract their records. You do not need an index on this sorting field.

You use SQL - SELECT - views/SPT to extract the records the user needs to see. Your UI indexes those records on the sorting field.

The user interface lets the user move the records around. You change the numbers in the ordering field. The UI displays the records as if they are physically sorted. When you save the changes back everything is done very fast.