Hi Kamal
>>When I try to 'Locate' or 'Go Top' etc, it is very slow. So, I try to create an index on the view. But, creating index on this huge table is very slow(4 mins).
>>
>>My question is, how can I make the retrieval fast and still don't take much time on creating indexes while opening my application.
You wrote:
>You dont. The idea with a client-server design is that you ask your users what they want to work on. Use these values as parameters and requery() a parameterized view, thus limiting the number of records.
My situation again:
My users want to see the last record entered into the table whenever they open the app. The last record entered(maintained as a primary key value) is maintained in a seperate table for the users to keep track of.
So, to show the last record in the view, I need to do a 'Locate' or 'seek'
My question is, should make the view parameterized based on the p. key value?
But, if the user searches the table on other fields(which occurs often), should I change the parameters of the view??
Also, Is my situation too difficult to use Client Server??
P.S: The users do lot of locates while using the app.
Hope I'm clear with my question.
Thank You
Previous
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