What would be the Causes of a Slow Exucute Data file on Navicat?

[Snailz]

<Tite>

Please Help me its going slow for some reason i dont know, I Want to know some causes that may make it do this.

[Steph]

Its because the programs used to dump the SQL comment the code poorly which takes it longer to execute.

If you execute from seperate tables its less of a problem - for example my old dumps, and my new NCDB releases. The new releases are tables only, the old ones were one big dump. The newer tables take a lot less time.

[Snailz]

Kk Ty There Steph

[Snailz]

Must Spread Rep

[Steph]

Dont worry, Im not bothered about rep.

[Snailz]

Ok so Im Guessing This is Slow.?

[Snailz]

I Tryed it with Stephs Db but they dont wana go any faster than that.

[Steph]

If you use my 988:

Filebeam - Free Fast File Hosting

All you do is import via the tool.bat batch file, and it takes a lot less time, you dont use Navicat.

[Snailz]

Aa k Ty all fine now Ty Steph /smile.

[latruwski]

you can always use tool.bat file to import DB stuff
http://www.mmowned.com/forums/emulat...db-faster.html


grtz

[Steph]

I honestly didnt realise that dumping took so much longer, I rarely import from dumps, and of course when I use a new version of NCDB, I just use their batch file.

It only started happening recently, but Im too tired right now to try and think why it might have been.

Hopefully if people start releasing batch files and individual tables, it should speed the processes up for everyone.