Hi, it sounds to me that you are not using any indexes. In UD there is CREATE.INDEX and BUILD.INDEX commands you need to run.
Björn Eklund -----Ursprungligt meddelande----- Från: Cesar Riba [mailto:[EMAIL PROTECTED] Skickat: den 19 februari 2004 16:04 Till: [EMAIL PROTECTED] Ämne: [UV] Very slow SQL query Hello, I have two files one has 300.000 records and another has 200.000 records, I wante to make SQL Query whit the two files and this takes bettewn 30 seconds and 1 minute to return the result. However, I have a program with BASIC to obtime the same result and it takes less than one second, I have heard that other DB Systems like SQL Server, Oracle, etc... are very fast with the SQL Query. Is this posible or do have I made a mistake? Thanks César -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users