GTRR as a sort method, but return to same record?

[aharown07]

Seems like I used to know how to do this... And I'm sure it's been answered, but I can't seem to come up with the right search string.

 

I've got a table w/12,000 records in it.Ton of fields, several unstored calcs. It sorts rather slowly using the Sort command.

 

Solution, I thought: set up a self-join TO with the sort set up in the relationship. GTRR to the TO.

 

It does seem to be quicker. (The self join is by a numeric field crossproduct relationship)

 

But... it doesn't retain it's current location in the found set. That is, I want to sort with record X selected, and after sorting, still be at record X.

 

How to do that?

[bcooney]

I really don't see how gtrr would speed up a sort. You could sort on a layout that doesn't contain any unstored calcs. That should speed things up.

 

Your current record doesn't change when you sort, so I don't understand your question - but I wouldn't gtrr.

[aharown07]

Thanks. Yeah, I think you're right. Thought I read somewhere that a GTRR via a sorted relationship was qicker... It certianly seems to do "finds" faster.

But with some playing around... I'm not seeing a difference. So I'm back to going to a vanilla layout, freezing the window and doing the sort.

[bcooney]

Take the unstored calcs off.

[aharown07]

I'll be looking at that. I think there are several that will have to stay. But I'm sure there are ways to replace some of them with auto-enter replace calculations and store them.

[bcooney]

You may wish to examine transactional scripting. Also, you can have a server script populate stored number fields with unstored calc values in an overnight job or as often as necessary.