How many records are you talking about? But you are right, you are updating as many times as inserting.
Darryl [EMAIL PROTECTED] wrote on 14/04/2005 01:54:58 PM: > On 4/14/05, Darryl Lyons <[EMAIL PROTECTED]> wrote: > > 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 > > Good idea Darryl, but I think that would create just as much load as > updating the priority on the original table. I'm pretty sure doing > multiple inserts on a virtual index would be more db intensive than > multiple updates and you would have to do that even when you move an > item up one or down one. You's then have to do a join to display it .. > it's starting to get messy. > > -- > 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/ 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/
