Poor Laptop

I use a Sony VAIO PCG-TR1A 900mhz Pentium-M with 1gb RAM to run all of my webMethods apparatus. Since the harddrive is only 30gb, I run SQL2000 because it seemingly takes up a smaller foot print on the drive.

Anyway, lethargic describes the length of time it takes to view my audit or error logs, so today, I dropped all of my tables in my webMethods support schema by running the following drop and create scripts. These are located in the /common/db/scripts/[drop | create]/

I ran the following drop scripts:

drop_iscoreaudit_6-0-1.sql
drop_processaudit_6-0-1.sql

then I ran

create_iscoreaudit_6-0-1_SQLServer.sql
create_processaudit_6-0-1_SQLServer.sql

which produced a snappy response time when I pressed on the links relating to the error or audit logs.

I had previously created code that ran a db cleanup function that archives the data 1 day after occurence and deleted data 10 days after occurence.

My problem is that I had too many rows in the database and any attempts to trim rows, delete, etc generated a timeout error. This occurred in the SQL Query Analyzer as well which resulted in the dropping and creating of the tables.