Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Views that return the top N%
I have a couple of questions about views.
---
1. I have seen where I can set up a view to return the top 10% of the matches. And if I'm not mistaken, this is done to speed up the return... Is that right?
---
2. After I've gotten my 1st 10% back and refreshed my display...
How do I get the next 10%, and the 10% after that, etc. ?
---
Part of what I'm trying to do is to speed up the loading of some of my forms. I have a couple that take about 10 - 20 seconds to load... that's better than my original design, but still a lot longer than the 1-3 seconds I'd like.
The forms have 6- 10 views each. Each view is setup as NODATAONLOAD.
The one form has a Command Button and a PageFrame (The PageFrame has 6 pages. Pages 1-5 have about 25 textboxes each, along with a couple edit regions and comboboxes. The last page has a textbox and a grid. The grid has 15 fields - 2 of which are combo boxes) This Form takes 10-20 seconds to become ready.
Another form has a combo box, two textboxes, and a readonly grid that I use to display the data of 1 of 5 views. (When the user selects a view to use the Grid's RecordSource is updated.) This Form takes about 10 seconds to become ready.
What can I do about this?
-------------------
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement