I am using TTables to hold a vendor table in Oracle. Everything was fine until the user dumped 55000 records into it. Now it takes 75 seconds to post my purchase orders. (was <5 seconds) I don't understand the connection. The vendor is simply a field in the purchase order table. Anyway, is there anyway to tweek the database so posting is faster?
(One example was to include not null on fields that indexes during table creatation. Apparently, Oracle will ignore the index if it finds a null.)