Notes ODBC Taking Too Long

Hi,

I'm currently making use of Oracle Forms45 to retrieve records from a Lotus Notes view via a Notes SQL ODBC Ver 2.0. When I issue a SQL statement to retrieve records without a "Where" clause, the respond is about 3-4 secs for 2000 records. It becomes very slow when I issue a "Where" clause to the SQL statement. It takes about 25 mins to retrieve all the relevant records. What could be the problem? Ready appreciate if someone and give me a solution to this problem.

TIA .... Mun Kong
Principle Software Engineer
Singapore Economic Development Board Received on Fri Nov 15 1996 - 00:00:00 CST