Hi. I have a standalone java GUI application. It basically reads around 7000 records in a table and uses data from there to search other tables in order to do some calculations and take consolodate the data and insert into another table. The tables that get searched within the outer loop, have in excess of over 500 000 records. I have put indexes in the inner lookup tables, but the method takes over 15 mins to run. Whereas the same logik done on a clarion system gets done in 3 mins. PLEASE HELP! I tried changing the calls to get the data from inner tables to use stored procs. I am not having any joy!