Postgres/Perl performance help needed

[Madison Kelly]

Hi Jim,

   That was my first though; to just delete the data relative to the 
partition I was working with and reload it, but there is a flag I need 
that will be set by the user.

   This is a backup program so when I user selects a file or directory 
the database is updated to remember that the user had selected it for 
backup. If I deleted all the existing data that would go to and thus the 
user would have to select what files they wanted to backup every time 
they opened up the partition...

   Darn this is complicated... :/

Madison

Jim Rootham wrote:
> Hi Madison
> 
> Is there associated data in the database that must be maintained?
> Or are there records which may not be deleted?
> 
> If neither I would suggest starting with empty tables and updating
> without checks or indices.  Create the index after for lookup purposes.
> 
> If you need to hang on to existing data you might try to load a temp table
> and create a new table using just SQL using a subquery to generate the
> data.    It's not really clear if this is faster in total.   Performance issues
> are like that.
> 
> Jim


--
The Toronto Linux Users Group.      Meetings: http://tlug.ss.org
TLUG requests: Linux topics, No HTML, wrap text below 80 columns
How to UNSUBSCRIBE: http://tlug.ss.org/subscribe.shtml