No triggers, No Primary/Foreign keys, Not a network issue as
tables that are 8 times larger update nearly immediately, and all
other indicators are great speed wise.(gigabit connection to the server)
Full unload reload of whole database 3 weeks ago for speed issues
then as well. Since this database is in use 24 hours a day I don't
know that I can kick everyone out and re-load the database more
often. I know it is a good habit, however it in the past has never
HAD to do it reguarly for speed. I would do it to keep it under 2
gigs with 7.5 and lesser versions.
At 08:33 AM 2/11/2010, you wrote:
Any triggers on this table? These can cause serious speed issues, if not
implemented properly.
Any Primary / Foreign keys on this table?
You stated you did a data unload. Was this for the entire database or just
the one table. If just the one table, I do not believe that helps
much. It could
be that your indexs are becoming troublesome and you need to do an entire
database unload/ reload. (Or try a pack index depending on your version)
Network or non-network?
Try projecting a temp table ..
Project Temp TmpTable from "Your Table" using all
This will create a duplicate with no indexes. Try your manual update on
this table. If it works fine, then your problem is most likely in
your database
index file (.xx3) or (more uncommon if you are using a network) a network
issue as the temp table most likely resides on your local machine.
-Bob
----- Original Message -----
From: "Dan" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Thursday, February 11, 2010 7:06:51 AM GMT -06:00 US/Canada Central
Subject: [RBASE-L] - Speed issues
I am not sure where to turn next. I have a table with about
100,000 rows... updating it seems to take forever. Just yesterday I
was manually changing a number in the table, then wanting to go to
the next row and change it... (needed to update about 20 rows) Each
row took 15 seconds before it would save and update.
So, I thought unload the data and reload. That was an hour ago,
unload took 2 seconds... reload is still going...If it is going
yesterdays speed it will take months.
Where am I going wrong?
