[FX.php List] Updating many Records - Best Practice?

[Denis Somar]

Hi Glyn,

I agree that portal updates are significantly faster that record by record
saves; however, I think there's an issue here that is being overlooked: are
your users legitimately going over and updating 1,300 records each visit?
 Couldn't you return the results, but isolate the edits by having them put
the records to modify into a shopping cart, for lack of a better term, then
retrieve the cart and edit there?

If I HAD to get the 1,300 records, this is what I would do:

   1. Do the search and return results
   2. Have the user select the records to edit before editing
   3. Store the selected record IDs in a session variable
   4. Have the user click on a Batch Edit/View Cart-ish kind of screen that
   retrieves the recIDs they want to modify
   5. Let them modify the data
   6. Update the modified records, which I sincerely hope is less than 1,300
   7. Worry about the next thing...

HTH,
Denis

On Tue, Jan 31, 2012 at 10:17 AM, Glyn Devine
<glyn.devine at quickseries.com>wrote:

> Hi all,
>
> I'm writing a web-app to talk to my company's filemaker database. It's for
> inventory.
>
> The app runs a query on the products table to find the ones that we're
> checking inventory for, this usually returns about 1300 records. (This
> initial step takes about 3-5 seconds) I store the resultant FX array into
> the user's session. I use the array to allow the web app to quickly page
> through the products. The inventory numbers (3 fields - boxes, packs,
> units)
> entered by the user are stored in the array as well.
>
> Once all the inventory numbers are entered, I will have the user commit his
> entered inventory to the filemaker database. What's the best way to update
> 3
> fields each for 1300 records in a way that's not dead slow?
> Sample/pseudo-code would be appreciated. I've never actually used FX.php to
> WRITE to records before.
>
> Thanks!
> Glyn
>
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.iviking.org/pipermail/fx.php_list/attachments/20120201/5faa8600/attachment.html