Cfquery Blockfactor and Oracle9i

[djones]

I have been reading in many places to increase performance, increate the BLOCKFACTOR of queries to 100.  If I have a query that generally returns 5 rows should a blockfactor of 100 benefit, hurt, or not affect performance.  

I have tried using the blockfactor in the past by going through the app and if a query on average returned 30 rows I set the blockfactor to 30.  I didnt notice a performance increase at all and in fact in some places I notice some actual decrease.  So I removed the setting from all cfquery tags.  But I didn�t try just making all query blockfactor's 100.

Thanks,

David

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

---