I have following query:
SELECT SQL_NO_CACHE users.user_name assigned_user_name, accounts.* FROM
accounts LEFT JOIN users ON accounts.assigned_user_id=users.id where
(accounts.assigned_user_id='1') AND accounts.deleted=0 ORDER BY
phone_office asc LIMIT 620300,20
In your opinion,
I have following query:
SELECT SQL_NO_CACHE users.user_name assigned_user_name, accounts.* FROM
accounts LEFT JOIN users ON accounts.assigned_user_id=users.id where
(accounts.assigned_user_id='1') AND accounts.deleted=0 ORDER BY
phone_office asc LIMIT 620300,20
In your opinion, what group
Do you have an index deleted + name on the accounts table?
How many rows have deleted=0?
that depends because SugarCRM doesn't delete anything from DB just marks
item as deleted using this field.
Can you apply any more filter in the users table (like date)?
You are requesting all rows.
Marko Knezevic [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Here are my tables and queries i am running on them with index
explanations.
Hope this will help.
ACCOUNTS TABLE:
+-+--+--+-+-+
| Field
Good morning everybody!
We are working on a big project involving SugarCRM and in the end it will
contain around 1 000 000 records per table in MySQL database. Whole system
is running on dedicated server which consists of two Xeons @ 3 Ghz, 2 GB RAM
and two 150 GB disks @ 1 rpm running
See below, and check that the indexes are right, or that the queries
aren't
negating the indexes. I can run queries against a properly indexed table
of
26 million rows in less than a second on lesser hardware (ok, so the SAN
isn't lesser). The manual also contains a lot of information on how
Marko,
I have a table with 5,000,000 records that takes about 1 second
to show the results.
Perhaps your queries aren´t optimized properly.
Ronan
Here are my tables and queries i am running on them with index explanations.
Hope this will help.
ACCOUNTS TABLE:
I also have following situation:
SELECT count(*) FROM accounts LEFT JOIN users ON
accounts.assigned_user_id=users.id where ((accounts.phone_office like '01
389437%' OR accounts.phone_alternate like '01 389437%' OR accounts.phone_fax
like '01 389437%')) AND accounts.deleted=0
Explain
Rhino wrote:
Okay, you've convinced me that you need some Left Joins ;-)
I think you'll have to use a mix of Left Joins and Inner Joins. In
the cases where you need a row even if something doesn't exist, like
a subject who has an address but no phone number, use a Left Join. In
any case
Hello, first i would like to greet all of you because i am new on this list.
I am working on yellowpages application and am having some problems.
I have different tables for storing info about different companies, their
addresses phone numbers and their field of work (i can't remember exact
word
Rhino wrote:
Your design seems fine, although you haven't explained how the field
and field_lookup tables join to the others so I am making some
assumptions.
Table field_lookup has two values defined as primary keys: ID_company and
ID_field
Thus, using simple query like:
SELECT company.name,
11 matches
Mail list logo
