Article View: pl.comp.bazy-danych
Article #194805optymalizacja count.
From: M.M.
Date: Fri, 22 Jan 2016 19:37
Date: Fri, 22 Jan 2016 19:37
9 lines
1409 bytes
1409 bytes
W Postgresie wolno działa mi select count(*) from table; Moim zdaniem nie powinno to działać wolno. Silnik bazy może sobie zliczać na bieżąco ilość rekordów i podać wyniki. Jest jakaś opcja do tego, aby nie pisać procedur w zdarzeniach? Pozdrawiam
Technical Details
Message-ID:
<c66d991f-8f3a-4aa9-b6f6-32eb82e4d1e8@googlegroups.com>Path:
mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!agh.edu.pl!news.agh.edu.pl!newsfeed2.atman.pl!newsfeed.atman.pl!news.nask.pl!news.nask.org.pl!newsfeed.pionier.net.pl!news.glorb.com!h5no8086624igh.0!news-out.google.com!kr2ni6212igb.0!nntp.google.com!o2no5355734iga.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mailShow Full Headers
Complete Article Headers
X-Received: by 10.66.146.193 with SMTP id te1mr4278174pab.17.1453491440054; Fri, 22 Jan 2016 11:37:20 -0800 (PST) X-Received: by 10.182.19.129 with SMTP id f1mr89346obe.20.1453491439958; Fri, 22 Jan 2016 11:37:19 -0800 (PST) Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!agh.edu.pl!news.agh.edu.pl!newsfeed2.atman.pl!newsfeed.atman.pl!news.nask.pl!news.nask.org.pl!newsfeed.pionier.net.pl!news.glorb.com!h5no8086624igh.0!news-out.google.com!kr2ni6212igb.0!nntp.google.com!o2no5355734iga.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail Newsgroups: pl.comp.bazy-danych Date: Fri, 22 Jan 2016 11:37:19 -0800 (PST) Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=178.37.225.160; posting-account=xjvq9QoAAAATMPC2X3btlHd_LkaJo_rj NNTP-Posting-Host: 178.37.225.160 User-Agent: G2/1.0 MIME-Version: 1.0 Message-ID: <c66d991f-8f3a-4aa9-b6f6-32eb82e4d1e8@googlegroups.com> Subject: optymalizacja count. From: "M.M." <mmarszik@gmail.com> Injection-Date: Fri, 22 Jan 2016 19:37:19 +0000 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit