Article View: pl.comp.bazy-danych.msaccess
Article #137423Re: Otwieranie formularza z recordsource - filtrowanie ok 300000 rekordów
From: LeszekN
Date: Thu, 23 Feb 2017 11:14
Date: Thu, 23 Feb 2017 11:14
12 lines
1938 bytes
1938 bytes
Zrób to samo tylko na tabeli powiedzmy około 50 000 rekordów, wykonasz to jakieś 24 razy i będziesz miał taki sam wynik, czyli zapchana pamięć. Jeżeli wykonujesz SQL'a za pomocą VBA trzeba pamiętać o tzw uwolnieniu pamięci. recordset.close set recordset = Nothing sprawdz w "menedżer zadań" wartość pamięci przed i w momencie już zawieszenia oczywiście mogę się mylić ;) pozdrawiam Leszek
Technical Details
Message-ID:
<858e7f10-fb9e-44c2-b459-bb8c702a8d72@googlegroups.com>Path:
mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!agh.edu.pl!news.agh.edu.pl!news.cyf-kr.edu.pl!news.nask.pl!news.nask.org.pl!goblin2!goblin.stu.neva.ru!weretis.net!feeder6.news.weretis.net!feeder.usenetexpress.com!feeder1.iad1.usenetexpress.com!216.166.98.84.MISMATCH!border1.nntp.dca1.giganews.com!nntp.giganews.com!e137no435513itc.0!news-out.google.com!78ni1666itm.0!nntp.google.com!e137no434277itc.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mailReferences:
<a22ebd07-c44a-4c54-9842-a8756c8a0bcc@googlegroups.com>Show Full Headers
Complete Article Headers
X-Received: by 10.157.35.119 with SMTP id k52mr10604266otd.92.1487848497235; Thu, 23 Feb 2017 03:14:57 -0800 (PST) X-Received: by 10.157.32.161 with SMTP id x30mr2719555ota.20.1487848497187; Thu, 23 Feb 2017 03:14:57 -0800 (PST) Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!agh.edu.pl!news.agh.edu.pl!news.cyf-kr.edu.pl!news.nask.pl!news.nask.org.pl!goblin2!goblin.stu.neva.ru!weretis.net!feeder6.news.weretis.net!feeder.usenetexpress.com!feeder1.iad1.usenetexpress.com!216.166.98.84.MISMATCH!border1.nntp.dca1.giganews.com!nntp.giganews.com!e137no435513itc.0!news-out.google.com!78ni1666itm.0!nntp.google.com!e137no434277itc.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail Newsgroups: pl.comp.bazy-danych.msaccess Date: Thu, 23 Feb 2017 03:14:56 -0800 (PST) In-Reply-To: <a22ebd07-c44a-4c54-9842-a8756c8a0bcc@googlegroups.com> Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=193.192.179.172; posting-account=i0RtOwoAAABRI8EWUf_BQOpbS6yj4J_N NNTP-Posting-Host: 193.192.179.172 References: <a22ebd07-c44a-4c54-9842-a8756c8a0bcc@googlegroups.com> User-Agent: G2/1.0 MIME-Version: 1.0 Message-ID: <858e7f10-fb9e-44c2-b459-bb8c702a8d72@googlegroups.com> Subject: Re: Otwieranie formularza z recordsource - filtrowanie ok 300000 rekordów From: LeszekN <leszeknowak@wp.pl> Injection-Date: Thu, 23 Feb 2017 11:14:57 +0000 Lines: 17 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit