Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-access > #10433
| From | "Ron Paii" <None@none.com> |
|---|---|
| Newsgroups | comp.databases.ms-access |
| Subject | Re: what is fastest way |
| Date | 2015-02-26 11:41 -0600 |
| Organization | A noiseless patient Spider |
| Message-ID | <mcnlrm$3e3$1@dont-email.me> (permalink) |
| References | <20d51e02-c174-4daa-8409-88c04338a2f0@googlegroups.com> |
"bobh" <vulcaned@yahoo.com> wrote in message news:20d51e02-c174-4daa-8409-88c04338a2f0@googlegroups.com... > Hi All, > > In Access2007 I have this form which has several listboxes on it, over the > last few months the opening of the form and the loading of these listboxes > takes longer then it used to. Something has changed but I don't know what, > IT says they have done nothing but,............ > > Anyways, I'm looking to see if there is anything I can do to the loading > of the lIstboxes to speed them up. Using one of the listboxes as an > example currently the rowsource equals this sql statement > > SELECT tblAllARWorking.DivMne, Count(*) AS Expr1 FROM tblAllARWorking > WHERE (((tblAllARWorking.PODGrpr)=[Forms]![frmMainMenu]![bxPODGrpr]) AND > ((tblAllARWorking.AssignedTo) Is Null)) > GROUP BY tblAllARWorking.DivMne; > > question I have are; > and yes this is a split db and the backend tables are in an Access2007 db > on the server. > > 1. Is there a better way to write this SQL so it performs quicker? > 2. Can the rowsource call a function or sub? > 3. If yes to 2 then, would re-writing the SQL as a sub/function using ADO > code be faster? > 4. If yes to 3 then, what would that ADO code look like? > > thanks > bobh. Verify the an index on [DivMne] exists. Compact / Repair on the BE can remove an index on damaged columns.
Back to comp.databases.ms-access | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
what is fastest way bobh <vulcaned@yahoo.com> - 2015-02-26 08:13 -0800
Re: what is fastest way "Ron Paii" <None@none.com> - 2015-02-26 11:41 -0600
Re: what is fastest way bobh <vulcaned@yahoo.com> - 2015-02-26 09:49 -0800
Re: what is fastest way Patrick Finucane <patrickfinucanetx@gmail.com> - 2015-02-26 10:58 -0800
Re: what is fastest way bobh <vulcaned@yahoo.com> - 2015-02-27 08:53 -0800
Re: what is fastest way Larry Linson <larry.linson@verizon.net> - 2015-02-27 16:06 -0600
Re: what is fastest way CDMAPoster@fortunejames.com - 2015-03-04 09:17 -0800
csiph-web