ave had complex searches that would simply time out - broke them into multiple simpler searches and combine the results in script. this is true for any relational database query not just NetSuite.