We have a very small piece of software that queries our inventory. once you have selected a product (very quick table has 32k records) and you want to see who has ordered that product it takes minutes (usually about 5) to query that table (830k records) looking for suggestions about how to speed up that query or maybe the DB in general. When you do the same program in a Native AS400 program it is instant.
November 18, 2005 12:54 PM
November 20, 2009 5:00 PM