Best way to keep my references straight?? Between all the processing

Looking for insight into keeping proper references between all the parsing,
processing, analyzing, sorting, replacing etc of my data.

  • I’m starting with an XML
  • create an array of nodes (via Xpath)
  • creating a list of records (this will be my master, all indexed by ITEM)
  • turning that into an Array
  • parse that Array into separate mySQL tables (using Shane’s Lib)
  • analyze, sort, etc into some new tables
  • ask user to double check and select final changes/selections
  • merge some data, replace some data, delete some data
  • create a new master list of records (or Array)
  • update the XLM nodes based on this new master list

I have created a record labeled “ENTRY_ID” for each item and they each have an individual value
I thought I should do this just in case?

I understand I should probably used Index Set Arrays.
I also love stuff like Nigel’s Quicksort with the ability to have slave lists follow.
Any other ASOBJc tips and tricks?

I am learning about indexing and Foreign Key Indexing in mySQL table creations.
I have been playing around with Navicat to attempt to build my dB and
link objects that way rather than creating them with AS. I’d much rather just use AS to
enter the data into the tables and run a few simply queries.
Is there any guides or tips on using mySQL?

I’m not seeing anything too curveball yet as long as I’m keeping the same
List or Array Index Items referenced as I pass the data around?

thanks

Kerry