Uptime all the time

[j harvey]

I am looking for ideas on how to keep my app running all the time, even when uploading data that will replace the current data. Some of these tables will have a million rows or more. Ideas?

Thanks in advance,

John

[Mike Dewhirst]

On 23/01/2023 5:12 am, j harvey wrote:

I am looking for ideas on how to keep my app running all the time, even when uploading data that will replace the current data. Some of these tables will have a million rows or more. Ideas?

Almost a question for the PostgreSQL users list - assuming that is your DBMS. It will depend on so many aspects of what is actually happening during/after upload.

In theory, if you upload data in a single transaction - or even many transactions - there will be no impact on users until the moment of committing.

In practice, theory might be inadequate.

Thanks in advance,

John

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/8087a569-f379-4e0e-b3fa-92d281abad69n%40googlegroups.com.

-- 
Signed email is an absolute defence against phishing. This email has
been signed with my private key. If you import my public key you can
automatically decrypt my signature and be sure it came from me. Just
ask and I'll send it to you. Your email software can handle signing.