that depends because SugarCRM doesn't delete anything from DB just marks
item as deleted using this field.
Do you have an index for deleted column?
It should help.
Can you apply any more filter in the users table (like date)?
You are requesting all rows.
no, because purpose of this query is
"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
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,
Do you have an index "deleted + name" on the accounts table?
How many rows have "deleted=0"?
Can you apply any more filter in the users table (like date)?
You are requesting all rows.
How many rows do you have in the users table?
Ronan
--
MySQL General Mailing List
For list archives:
"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
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 say
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 have a table with 5,000,000 records that takes about 1 second
> >> to show the results.
> >
> > All rows?
>
> No. The queries return an average of 30 rows.
>
> I just wanted to say that the problem isn´t the table size, but the
> query X indexes used.
Right :-)
I just wanted to say that i
Martijn,
I have a table with 5,000,000 records that takes about 1 second
to show the results.
All rows?
No. The queries return an average of 30 rows.
I just wanted to say that the problem isn´t the table size, but the
query X indexes used.
Ronan
--
MySQL General Mailing List
For list ar
>
> I have a table with 5,000,000 records that takes about 1 second
> to show the results.
All rows?
> Perhaps your queries aren´t optimized properly.
With regards,
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.up
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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Tuesday 22 Nov 2005 10:02, Marko Knezevic wrote:
> > 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
>
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 t
on 11/22/05 1:24 AM, Marko Knezevic at [EMAIL PROTECTED] wrote:
> We've been testing the system with 100 test records to see how it will
> work when doing selects from db and we are pretty disappointed with the
> results. Some selects needs around 10 seconds to finish, some take even
> longer.
On Tuesday 22 Nov 2005 09:24, Marko Knezevic wrote:
> is running on dedicated server which consists of two Xeons @ 3 Ghz, 2 GB
> RAM and two 150 GB disks @ 1 rpm running under RAID 1 controller. OS is
> CentOS 4.2
A very recent article that crossed my eyes indicates that in certain cases, HT
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 und
16 matches
Mail list logo
