* Stig Nørgaard Jepsen > > Do you need to read _all_ textkeys for each page? How many different > > textkeys do you have in the table? > > No I don't have to read all the textkeys at once. They are > usually selected via a join from another table. And sometimes I > will read a set of rows via a sectionid. > Right now, I don't have many textkeys... but the number will > increase quite a bit! I would imagine around up to 500 rows per > language max. And I think that 2-3 languages will be usual.
With this small amount of data the query will probably execute fast even if you had no index. > Yes, but now as I have seen how quick this query is, then I don't > think I have much to worry about :) sounds good. :) > I just made a little 'Query Tester' script in PHP, where I can > see how much time is spent before the mysql_query() function is done. > I really like my little program. It's much easier to test > queries, than i fx. PhpMyAdmin. Don't know if you program in PHP > and use PhpMyAdmin, but I had some errors, when running a query > where I use aliases on tables and when I have a fieldtype of text or blob. No, I have not used PhpMyAdmin. (I read your posts about the blob/text problem.) I have tried PHP, but mostly I use Python. > Oh, so you are from Norway! My sister lives in Norway too... > Vikersund not far away from Drammen :) > Ha' det godt og tak for hjælpen - so far :O) :) -- Roger --------------------------------------------------------------------- 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
