On Mon, Sep 26, 2005 at 05:55:18PM +0530, surabhi.ahuja wrote: > i have seen that after insertion say (20 k rows) the insertion to tables becomes slow..why is it? Most likely due to indexes. > is there any way in which u can stop the performance from degrading If you're loading from scratch, don't create the indexes until after the load is done. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@xxxxxxxxxxxxx Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
