General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
John,
Can you show us the command(s) you are using to pull the 5000 records *and* the exact expressions for each TAG in the table(s) involved?
It still may be that you are not fully exploiting Rushmore.
Good luck,
JimN
>Hi,
> Thank you for your suggestion.
> I have change my ALLTRIM(Card_no) to card_no for my index. However, it still take 1 minute to pull 5000 records from my server.
> I have tried to set my server network setting from 10 Full mode to AutoMode. It seem the performance improve alot!!!! 4 SECONDS!!!! It is same performance with 100 Full mode.
> Any ideas?
>
>Thank you
Previous
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