Re: Performance of mid-sized tables?

jkormann@beast.Trenton.EDU (Joseph Kormann) wrote: :We're using SE5.02 and our most-heavily read tables are getting up to :about 100,000 records. We've noticed that the seek and reads on them is :degrading. Rather than splitting them to 50,000 tables, does anyone have :an idea of how to improve performance? Check your application (set explain on) and tune that. For the database you can do the following: 1. Drop all indexes (including primary keys). 2. Unload the table and drop it. 3. Create the table and reload all data. 4. Create the indexes. Doing only 1 and 4 might also help, particularly if you haven't deleted many rows. You might also want to check fragmentation at the Unix level and do something about that. :On a similar issue, we are running on a HP-UX K200 system (192meg ram) :and recently added the second processor. We noticed that the system got :slower rather than faster. Does anyone know how to split the processing :up among the processors? I know nothing about this. Nils.Myklebust@ccmail.telemax.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company