Hi,

I have a question that would probably get a wider audience in the "views" category, but I would rather get MM specific answers...

I've been experimenting with views a lot since the ones I'm using tend to combine 3 or more tables and in spite of vfp's impressive speed, it seems like rushmore is not kicking in.

Let me give you an example:

If I do:

select requests.iid, providers.lname, lawfirms.name from ;
	requests, case_def, lawfirms, providers ;
	where requests.iid = 123456 and ;
		providers.iid = requests.iproviderid and ;
		case_def.iid = requests.icasedefid and ;
		lawfirms.iid = case_def.lawfirm ;
	into cursor c0

it takes 0.8 seconds to retrieve the row of data I'm looking for.

If instead I break this single select into THREE:
1. Join requests and providers into cursor c1
2. Join c1 and case_def into cursor c2
3. Join c2 and lawfirms into cursor c3

The whole enchilada takes only 0.04 seconds (20 times faster!!!!!).

Remember that over a network, those 0.8 seconds become roughly 8 seconds, which isn't something my users will be thrilled about.


How do you handle this sort of thing? 

Is there a way to speed up a single view like the one I have at the beginning of this message or you make your bizobjs work with several simpler views instead, like I did with the 3 cursors (not that the view I'm breaking up is so complicated!)?

Thanks!

Alex

Low-carb diet not working? Try the Low-food diet instead!