Yeah, if you use a bridging table to store the recordID and priority, then index that table by "record ID, priority", it would be quite quick. You'd just have to blow away the data each time in that table and then reinsert.
Darryl Lyons [EMAIL PROTECTED] wrote on 14/04/2005 01:36:10 PM: > > jason, > > how about blowing away the records from the db table and re- > inserting them? (using the new prioty index) > > this is provided you've got all the data you need for those records > to insert them back again and it won't upset any foreign keys... > > just a thought > > cheers > barry.b > > > > > > > > > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] Behalf Of Jason > > Sheedy > > Sent: Thursday, 14 April 2005 1:23 PM > > To: CFAussie Mailing List > > Subject: [cfaussie] RE: ordering records by priority > > > > > > On 4/14/05, Steve Onnis <[EMAIL PROTECTED]> wrote: > > > you could use a select box with some buttons to move the > > items up and down, > > > then use the position in the list when it gets submitted to > > re order your > > > items > > > > Hi Steve, > > I probably wasn't very clear in my description because I didn't go > > into the actual method of displaying it, but that's kind of what I'm > > doing. I just have 4 buttons on each item, (top,up,down,bottom). > > > > My question was more to do with the method of storing the priority to > > make it more efficient in terms of database access. I don't want to > > have to update every record every time I change the priority on an > > item. > > > > -- > > Jason Sheedy > > www.jmpj.net > > > > --- > > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > > To unsubscribe send a blank email to > > [EMAIL PROTECTED] > > Aussie Macromedia Developers: http://lists.daemon.com.au/ > > > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to [EMAIL PROTECTED] > Aussie Macromedia Developers: http://lists.daemon.com.au/ To unsubscribe from this email please forward this email to [EMAIL PROTECTED] This email message is confidential and may be privileged. Unauthorised use, copying or distribution of any part of this email including attachments is prohibited. If you are not the intended recipient please forward the email to [EMAIL PROTECTED] and delete the original. ABN AMRO Morgans Limited and its associates hold or may hold securities in the companies/trusts mentioned herein. Any general advice included in this email has been prepared without taking into account your objectives, financial situation or needs. Before acting on the advice, you should consider its appropriateness or discuss with one of our investment advisors. To the extent permitted by law we exclude (and where the law does not permit an exclusion, limit to the extent permitted by law) all liability for any direct, indirect and consequential costs, losses, damages and expenses incurred in any way (including but not limited to that arising from negligence), connected with any use or access to this email or any reliance on information contained in this email or any attachments. ABN AMRO Morgans Limited (ABN 49 010 669 726 AFSL 235410) A Participant of ASX Group A Principal Member of the Financial Planning Association --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
