in-memory local database

Hello,
I believe, my requirement is bit complex for me(may be easy for you) :-). I would he happy if you could provide an effective solution.
The requirements is as follows.
I have a table or collection containing the product list with unique product ids.
Table1
IDs | Cat
AJU09Y | Beauty
GHY78L | Kitchen
GLK23J | Baby
HJUY1L | Auto

  1. When an user open the site, from the above table, IDs will be read and a remote API call would be made. On return, all the latest product details fetched will be saved on temporary collection.
  2. From this temp collection, data will be used to fill the page details such as repeaters, gallery etc.

However there are few constrains.

  1. There should be few calls made to the API servers.
  2. Data should be of latest information.
  3. Site admin should fill the above Table 1, need not to bother about filling the temp collection.

Apart from this I have few other questions

  1. In Wix, if a collection has read-write access to anyone, then if 100 users write the data to the collection at a time, then will there be any discrepancy in data? If yes
  2. Is is possible to create temporary collection for each users(guest users, not registered)? Once the user is out, the collection should destroy.

Thanks,
Raj