Hi all, With Rbase 9.5 32 on Windows XP this command works fine and very fast...
UPDATE scripts1 SET PRINTER = PRINTER FROM scripts t1, + scripts1 t2 WHERE t1.namedose CONTAINS= t2.shortcut AND t2.patnumbr = .vpnum AND + t2.PRINTER IS NULL With Rbase 9.5 32 on Windows 7, it takes 11 seconds to complete the same command, despite the faster processor and faster memory. NIC and Harddrive specs are the same. If I get rid of CONTAINS and change it to = like this.... UPDATE scripts1 SET PRINTER = PRINTER FROM scripts t1, + scripts1 t2 WHERE t1.namedose = t2.shortcut AND t2.patnumbr = .vpnum AND + t2.PRINTER IS NULL then it works instantly on both Windows XP and Windows 7. Both tables, scripts1 and scripts have an index on the column called namedose. What can I do to make it faster on Windows 7? Mike
