I’m managing an enterprise web application that uses Amazon’s RDS as our database server. Our architecture is such that when a user signs up for a new account we create a brand new database for them in RDS.
The database has around 63 tables, most of which have indexes, and almost all have foreign key constraints. Currently we’re creating each new database by executing a large set of sql statements. This takes on average 57 seconds.
Does anyone have any ideas for how I could do this quicker or more efficiently?
You might want to try and execute the query as a “bulk transaction” to skip the verification checks. Be warned, this can create duplicate indexes & break consistency checks if you’re not careful.
Leave a comment
- Is there a way for administrators to disable users from installing Firefox extensions?
- Is there research material on NTP accuracy available?
- How to create a limited “domain admin” that does not have access to domain controllers?
- Can Windows RDC admin users be immune from being kicked?
- Domain Administrators account policy (After PCI audit)