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
