[Babase] Speeding up large tables
Karl O. Pinc
kop at meme.com
Sun Mar 29 21:44:13 EDT 2009
On 03/29/2009 02:12:43 PM, Karl O. Pinc wrote:
> Catherine,
>
> You probably want to put some indexes on your
> big tables. It will make things much, much
> faster.
I can't recall if I've auto-vacuuming turned on.
If not then you'll want to "vacuum analyze" the table
after you delete or modify a lot of rows, add columns, etc.
I just looked and see that I don't have auto-vacuuming
on. I had this off for the conversion but really
think I should turn it on....
Karl <kop at meme.com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein
More information about the Babase
mailing list