Get Satisfaction uses Javascript and cookies.

You'll need to enable Javascript and cookies to log-in and participate.

Share it on these other sites

1 reply made

2 persons participating

1 employee helping

The mood in here

happy 1

silly 0

indifferent 0

sad 0

Products & Services

set the mysql key_buffer_size to ~30% of your total memory (default is something like 16mb)
use the myisam database engine

after importing (see Mo's idea page [link]):
- remove all pages from the "page" table that do not have the 0 page_namespace or are not redirects
- establish primary keys/indexes for id/join columns for tables (e.g. page_id, page_latest, rev_id, rev_text_id, old_id, etc...)
- test out different ways of making queries. remember your goal is to use the indexes in the table, which depending on how you form your query, mysql may not actually use. if you put the word "explain" in front of your mysql query it will show you how it is making the query, and which indexes it will use). for me, a bad query to join the 3 tables took ~20min, a good query took ~3sec.