Jump to content

Recommended Posts

Posted

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..

  • Like 1
Posted
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
Posted

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?

Posted

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).

Posted
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

  • nemo1 changed the title to [Solved] I can't setup website two week

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...