on-rev queries

[Bob Sneidar]

Hi Sarah. Thanks for the reply. 

Actually, when you use an admin application the very same queries that I am executing remotely are used by the admin app. There is no fundamental between difference using the web page to create and drop tables as there is making a remote connection via SSH or some other method and executing the sequel there. 

It is not at all odd to create and drop tables as I see fit. As I mentioned, it DOES work at times, and at others it does not. It beachballs at times and at others it does not. This has all the earmarks of timeout issues with the on-rev server. What I am trying to find out is if there is some kind of inherent restriction with certain kinds of queries with on-rev. If so, then I will not be able to use it. 

No one else is using the tables other than me. I have my site set up to only accept connections from my work's IP and my father's IP from his house in Hawaii. He doesn't even know what SQL is so that is not a problem. 

Bob


On Feb 2, 2010, at 2:04 PM, Sarah Reichelt wrote:

> On Wed, Feb 3, 2010 at 7:59 AM, Bob Sneidar <bobs at twft.com> wrote:
>> Hi all. Executing queries directly with the on-rev mySQL database I have seems to beach ball Revolution at times.
> 
> Hi Bob,
> 
> I haven't been following this thread very closely, but it seems that
> you are allowing odd things to happen, which may be part of the
> problem.
> As I envisage databases on a server, you set up the database & it's
> table manually using phpMyAdmin or the equivalent.
> 
> Web pages then get to read & write records, but do not mess with the
> basic structure of the database.
> 
> If you consider that there may be multiple concurrent connections,
> this makes sense as the table cannot be dropped if someone else is
> actually reading it at the same time.
> 
> I have used a MySQL database via On-Rev and it has seemed very fast
> for both reading & writing, but I did all the setup through cPanel and
> phpMyAdmin first.
> 
> HTH,
> Sarah
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution