Article View: pl.comp.bazy-danych
Article #194616Re: [mysql] Jak przyspieszyć wczytywanie dumpa
From: M.M.
Date: Wed, 23 Sep 2015 10:51
Date: Wed, 23 Sep 2015 10:51
9 lines
1614 bytes
1614 bytes
On Tuesday, September 1, 2015 at 6:09:42 PM UTC+2, Robert Winkler wrote: > [...] > Robert Sprawdzałeś, czy plik z wczytywanymi danymi jest optymalny? Najpierw gołe definicje tabel, potem inserty, potem testy poprawności, potem indeksy, na końcu więzy integralności Pozdrawiam
Technical Details
Message-ID:
<309b4443-d08d-44a7-96b0-639d37187d4e@googlegroups.com>Path:
mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!newsfeed.pionier.net.pl!feeder.erje.net!1.eu.feeder.erje.net!newspeer1.nac.net!border2.nntp.dca1.giganews.com!nntp.giganews.com!v79no3373746qge.0!news-out.google.com!f6ni13445igi.0!nntp.google.com!kq10no7580052igb.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mailReferences:
<55e5cdb5$0$8373$65785112@news.neostrada.pl>Show Full Headers
Complete Article Headers
X-Received: by 10.129.39.87 with SMTP id n84mr26841938ywn.4.1443005484221; Wed, 23 Sep 2015 03:51:24 -0700 (PDT) X-Received: by 10.182.116.165 with SMTP id jx5mr140204obb.27.1443005484079; Wed, 23 Sep 2015 03:51:24 -0700 (PDT) Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!newsfeed.pionier.net.pl!feeder.erje.net!1.eu.feeder.erje.net!newspeer1.nac.net!border2.nntp.dca1.giganews.com!nntp.giganews.com!v79no3373746qge.0!news-out.google.com!f6ni13445igi.0!nntp.google.com!kq10no7580052igb.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail Newsgroups: pl.comp.bazy-danych Date: Wed, 23 Sep 2015 03:51:23 -0700 (PDT) In-Reply-To: <55e5cdb5$0$8373$65785112@news.neostrada.pl> Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=178.36.206.163; posting-account=xjvq9QoAAAATMPC2X3btlHd_LkaJo_rj NNTP-Posting-Host: 178.36.206.163 References: <55e5cdb5$0$8373$65785112@news.neostrada.pl> User-Agent: G2/1.0 MIME-Version: 1.0 Message-ID: <309b4443-d08d-44a7-96b0-639d37187d4e@googlegroups.com> Subject: Re: [mysql] Jak przyspieszyć wczytywanie dumpa From: "M.M." <mmarszik@gmail.com> Injection-Date: Wed, 23 Sep 2015 10:51:24 +0000 Lines: 8 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit