nemo1 Posted September 2, 2021 Posted September 2, 2021 I can't setup website from two week can you admin setup it to me
wolstech Posted September 2, 2021 Posted September 2, 2021 Users are currently not able to set up new websites due to the Plesk migration. You'll need to wait until the migration is completed for your server. We have no ETA as to when this work will be completed, though I can say Tommy will be the first server completed.. 1
nemo1 Posted September 2, 2021 Author Posted September 2, 2021 I have empty database and can access but every time setup corrupted in middle of setup and not all table setup and I clean the database and begin new setup but it's corrupted again my internet slow and may server not in very good load I well send you the database name and username and password may be you can setup
abisheak Posted September 7, 2021 Posted September 7, 2021 Hi Nemo1 san, I am not an expert. Just offering to help. In case of huge table with many records, do you use Insert for every record or insert ... values.... type? Many Foreign keys constraints? On insert or delete on update or triggers?
wolstech Posted September 7, 2021 Posted September 7, 2021 He was trying to install Drupal. That said, I do development as a hobby, database and related code design really vary by program. I usually do a separate INSERT per record when bulk inserting because a foreach or while loop is usually involved and it's much easier than doing string concatenation to build one, however if you're using something like prepared statements, I believe it assembles a single statement and executes it. I can say though that if the number of records to be inserted is massive, a single query with multiple VALUES statements is faster in my experience. I used to be against using constraints in my older code, but now use them quite heavily in my modern apps. Not only does it make for a cleaner DB, it also simplifies code, and eliminates the need to code in tedious things like update/delete code for multiple tables (the ability to CASCADE or SET NULL on a constraint means you can just run a single UPDATE or DELETE on the parent record and let the database server worry about updating/removing other lines that reference it, the desired action of course depends on what you're doing).
nemo1 Posted September 9, 2021 Author Posted September 9, 2021 On 9/7/2021 at 6:32 AM, abisheak said: I am not an expert. Just offering to help. thank you On 9/7/2021 at 1:27 PM, wolstech said: He was trying to install Drupal. thank you
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now