General information
Category:
Coding, syntax & commands
Title:
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?
-------------------
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only