Very Slow SQL Import

[Philipp Mühlmeister]

Hi,

I started using Sequel Pro a while ago and received some weird problems now.
I tried to import a 10 MB SQL file into the database using Sequel Pro. But it uploads with about 10 KB/s while PHPmyAdmin is uploading with 200 KB/s.

What's the problem here? I used Sequel Pro before and never expected that behavior?!

Can somebody help?

Thanks in advance,

Phil

[Rowan Beentje]

Hi Phil,

I've got one theory...

The main difference for imports between PHPmyAdmin and Sequel Pro is that PHPMyAdmin is (typically) running on the same server or network as the MySQL Server, whereas Sequel Pro can run from a different location. This means that ping/lag will typically be higher for Sequel Pro.

Depending where you got the SQL file from, it may use lots and lots of small queries. Each of these is run individually, which magnifies the effects of ping; in a high-bandwidth high-ping situation, this means that running the import from PHPMyAdmin will be faster.

Many programs attempt to batch queries in exports for that reason. For example, when you generate a SQL export with Sequel Pro, it tries to combine the data into queries of around 250k in size, to minimise the effects of network ping on a subsequent re-import.

If you look at the SQL file and the network conditions, does that sound like it might explain it?

Rowan

> --
> You received this message because you are subscribed to the Google Groups "Sequel Pro" group.
> To view this discussion on the web visit https://groups.google.com/d/msg/sequel-pro/-/9mx28pkxqScJ.
> To post to this group, send email to seque...@googlegroups.com.
> To unsubscribe from this group, send email to sequel-pro+...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/sequel-pro?hl=en.