A query construction problem

2003-02-08 Thread Blaster
I can't think of a way to do this, any help is appreciated =) Imagine the following tables table "usr" (holds all users) id (int) | name (varchar) table "clanlist" (holds all clans) id (int) | name (varchar) table "clanmembers" (holds all members of all clans) uid (int, points to a user in "usr

A little problem with SELECT

2003-01-16 Thread Blaster
Hello, I have a really tough problem here, I can't think of a way to make this work Imagine 2 tables, the first one is the "main" table where I keep listings of companies and "general" info about them. In the second table, I keep 1 row for each employee and an field which points to the company

Enabling Cache feature in MySQL 4

2003-01-10 Thread Blaster
Hello I've been running MySQL 3.23.49 as my DB for my webpage since up till now. The number of visitors have been increasing, and the poor box is currently running at 100% load, 24/7, which can't be healthy, and the page is getting slower to load. I've checked all my queries and tried to optimiz