on-rev queries

[Sarah Reichelt]

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