I am looking for mainly a low power or at most a single 6 pin connector NVIDIA card to be used as a dedicated PHYSX card.
Currently I am using 240GT is that sufficient or should I upgrade to something better? Will I see any gains if I upgrade?
The GT 240 is too slow to benefit a GTX 780. It WILL slow down your performance. At a minimum, you should be looking at a GTX 650. The keys are cards that have both high core clocks and a high CUDA core count, with the GTX 650 as your minimum yardstick.
This is from about the only set of benchmarks using recent video cards for dedicated PhysX, and a high-end primary graphics card. http://1pcent.com/?p=169
As per Nvidia:
Which NVIDIA GeForce GPUs support PhysX?
The minimum requirement to support GPU-accelerated PhysX is a GeForce 8-series or later GPU with a minimum of 32 cores and a minimum of 256MB dedicated graphics memory. However, each PhysX application has its own GPU and memory recommendations. In general, 512MB of graphics memory is recommended unless you have a GPU that is dedicated to PhysX. - See more at: http://www.nvidia.com/object/physx_faq.html#q3
Don't bother with a Physx card. In most cases, it actually slows everything down because the main card has to wait to communicate with the physx card. Especially with something as powerful as a 780, it's just pointless.
The GT 240 is too slow to benefit a GTX 780. It WILL slow down your performance. At a minimum, you should be looking at a GTX 650. The keys are cards that have both high core clocks and a high CUDA core count, with the GTX 650 as your minimum yardstick.
This is from about the only set of benchmarks using recent video cards for dedicated PhysX, and a high-end primary graphics card. http://1pcent.com/?p=169
That's because his graphs are showing the use of very high end cards.
Just google the issue; it is very commonly known that using a low-end card like a GT 240 with a powerful main GPU is going to result in worse performance.
+1^
And at the very least, you will have an enclosed system with less air flow, more heat generated, more resources wasted, and negligible performance to show for it.
I can't do proper research right now, but there is some info available through Google, Tom's Hardware, physxinfo.com, and Linus Tech Tips has a very good YouTube video on the subject.