I have the same problem….it acts like indexes are not being used.  The only workaround I have found is to try using different columns for the search criteria….seems to like integer and real columns, does not like date columns.

Hope that helps.

 

Mike Sinclair

 

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Atrix Wolfe
Sent: Friday, December 27, 2002 6:58 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - sconnect and sattach

 

Recently i have been trying to use sconnect and sattach to do a select which uses 2 tables from 2 different rbase databases.  I got it to work where i can select from the foreign table and edit it, but when i do a select which uses the foreign table and a local table, r:base just hangs (waited 5 minutes before giving up on a relatively simple query).  Is this because sconnect and sattach add significant overhead to doing a join?  Is there any way to overcome this?

Reply via email to