Fast bcp requisites 1

[Guest_imported]

Hi,

what do I need to drop to ensure that I will be using a fast bcp.

I'm pretty sure about Indexes (including primary keys) but not that much about if I need to drop foreign keys and triggers, references, or even default values. I've read that I need to drop triggers, but I don't understand why, as they are not triggered by normal bcp.

Is there any sp /Unix script that given the table name, drops all these things?

Thanx,
Roberto

 

[qyllr]

hello,

to ensure fast bcp... i normally drop the following:

indexes
primary key constraints - constraint
foreign key constraints - references

as far as the triggers, the only thing i can think of are safety triggers... i don't normally drop them unless i do multiple updates on a table...

i maintain two config files one for normal operations and one for fast bcp configuration...
i change the wash and pool sizes in the config file to speed up the bcp in... these values vary so please refer to the sybase manual on performance tuning on configuring the server... for more info

hth,
q.

 

[qyllr]

hello,

you need to write a script to drop/add these objects...

the best thing to do:

run sp_helpindex to get all the indexes...
run sp_helpconstraint to get all the foreign key constraints...

then do a drop/create index statement to drop/add the indexes and alter table for dropping/adding the foreign key constraints...

q.

 

[Guest_imported]

Thanks a lot!
Roberto