Hi all. Anyone have any idea how fast the queries to the On-Rev SQL databases are on average? I was using a method where I was looking up a key from one query of 100 records at a time and querying a mySql database at my On-Rev site ONE RECORD AT A TIME! I discovered that the queries were taking about a second, which now that I think about it, is about right, with internet lag and all.
So now I have to think about using joins. My problem now becomes, I am looking up values from a table in one database, in a table tables residing in another database. Can I even create a join like that? Don't the tables have to reside in the same database to do a join like that? <sigh> Barring that, I suppose I can compile a list of key values, and do a single query for records with key values in that string, then loop through and add the records that don't exist, but how to do that with a single query! Sheesh! If I were using Foxpro this would be child's play. I'm wondering if the Relational aspect of Trevor's sqlYoga would be able to do this, but again, I think I have to be working with two tables in the same database for that to work. Trevor? Bob _______________________________________________ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
