General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>I see from later dialogue that you are ready to accept this as 'normal'.
>I would say that you should be able to get better myself, and by much too.
>Does a BROWSE take as long when you have set the index to bed and opened the BROWSE with the Key option (for your example below)?
>I suppose that RAM could be implicated here -large indices may not be able to be efficiently loaded?
The browse take 6 to 7 seconds (even with the method above). I have 64megs of RAM on a PII.
Interesting note is that if I set a relation between this large table and a parent table and then choose record in the parent table... the child records are displayed instantaneously. This means that relations between tables are implemented are a more fundamental level than a SQL statement. Perhaps I can harness this concept in my query...
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