RE: MySQL vs. Oracle (not speed)

[Mary Stickney]

I did crash the MYSQL server the other day...

I am currently looping thru and getting the sales agent by agent.
I tried to do the query for all 804 agents at one time and after an hour and
a 1/2 and still not being done
decided against doing it that way.

next I decided I should have a table already made of all these tables joined
for reporting purposes, it would speed my reports.
well I tried to join them all and insert them into another table ... crashed
big time on that one...




---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php