bobo I doubt that the table will be too big myself given the limitations which you will find in the mysql manual (far above your requirements). Spend a bit of time and calculate the actual size of the table - while it sounds huge you might be pleasantly surprised. A database of properties in a local government area of some half a million records at around 1k or 2k each was quicker than my wildest dreams on various searches and selects, not admittedly on text/blob fields though.
mySQL specifics are slightly off topic strictly speaking - if anyone grizzles just email direct. ----- Original Message ----- From: "Bobo Wieland" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, January 30, 2003 6:21 PM Subject: [PHP-WIN] MySQL - question > I'm most of the time using MySQL in conjuction with PHP and I hope that it's > okey to post questions regarding MySQL. There isn't much traffic here anyway > so I hope you can live with it... > > Anyway... I'm going to put two different translations of the bible in a > MySQL-db. And before I do anything I would like to know a couple of things > that I couldn't make out of the MySQL manual. > > Q1: This db won't be too big for MySQL to handle? > > Q2: My first thought was to use two tables like this: > > table1: > | book_id (PRI_KEY) | short_name | long_name | extended_name | bible_part | > > table2: > .--------------(PRI_KEY)-------------. > | book_id (F_KEY) | chapther | verse | txt1917(text) | txt2000(text) | > > > Is this a good idea? Table2 will get huge! Any better ideas? > > Q3: Can you do a search where the WHERE-clause searches the primary key in > table 2 or do I have to use "...WHERE book_id = '1' AND chapther = '1' AND > verse = '1'".... > > Q4: Can you order the data in table 2 in the db itself and not just when > displaying the results so that the first primary key allways will be | 1 | 1 > | 1 | and the last will be (in this case) | 77 | 22 | 21 | > > > Well... I think that is it... Please help me on this one. Feel free to > answer any or all of the questions... > > > thanks! > > > . bobo . www.elstudion.com . www.elstudion.com/bobo . > > > > > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
