Hi everybody! We are running Mysql on Linux. With a large database (aprox 25 mil rows in diffrent tables). We can't run joins because they lock the tables, so we have to write a script in c++ that takes out rows from one table and then take data from another table (a sort of fake-join). We also have alot of users running agains the database (using php). The problem as you probably already have figured out is: - - The tables lock when you make an update - - I know there are other table handlers. like Berkley (BDB) that only lockes on row instead of tables. Is this the bast way, or should we use another table handler. Or perhaps run mysql with --set_priority_low_for_updates please help me. Thanks, Johan (ps. If you recomend another table handler, which one is best for us?) --------------------------------------------------------------------- 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
