Hi, I'm hoping that some experienced Xano user might be able to offer a solution? I am working for a client who has a Launch account and they have a main table with a 100,000 records (each with about 25 fields).
They want to be able to upload a csv file (actually 3) and update the table. Not really a problem (thanks to a snippet by Chris) if the file(s) only contained new records, but the file(s) are a dump from other systems and contains all 100,000 records of the data (old, new and updated). I could potentially search for the equivalent record and overwrite that record, but I am pretty sure that I would run into memory problems and I imagine it would be awfully slow. Please correct me if I'm wrong.
My other desperate thought was that I could create a new table (or clone the structure of the existing one), upload the data and then delete the original one and rename the new table, but I don't think the Xano api currently allows DDL operations.
Any thoughts or advice/solutions would be greatly appreaciated.
thanks,
bren