[PHP-DB] Table optimization ideas needed

such as select a,b from table_name where c='d' will take. I have a lot of tables like that. So my questions is: What's your practice to optimize tables like that? Thanks in advance. -- Regards, Shelley -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

[PHP-DB] Table optimization ideas needed

such as select a,b from table_name where c='d' will take. I have a lot of tables like that. So my questions is: What's your practice to optimize tables like that? Thanks in advance. -- Regards, Shelley -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

Re: [PHP-DB] Table optimization ideas needed

Yes, Index can help a lot. But actually there has been five indices. The table takes 1.4G space while the indices take 2.3G. The select sentence is still slow. :( On Tue, Mar 25, 2008 at 11:50 AM, Chris [EMAIL PROTECTED] wrote: Shelley wrote: Hi all, I made a post a week ago to ask

Re: [PHP-DB] Table optimization ideas needed

. On Wed, Mar 26, 2008 at 10:20 AM, Chris [EMAIL PROTECTED] wrote: Shelley wrote: Yes, Index can help a lot. But actually there has been five indices. The table takes 1.4G space while the indices take 2.3G. The select sentence is still slow. :( Post your exact query, table definition(s

Re: [PHP-DB] Re: Table optimization ideas needed

Yes, Chris. You are right. I think I mentioned in the archive that the table is Innodb engined. Maybe Roberto didn't notice that. On Thu, Mar 27, 2008 at 7:26 AM, Chris [EMAIL PROTECTED] wrote: Roberto Mansfield wrote: Shelley wrote: Hi all, I made a post a week ago to ask

[PHP-DB] Re: Table optimization ideas needed

that. Actually, I wonder how facebook is dealing with this matter. Somebody knows? On Wed, Mar 26, 2008 at 10:05 PM, Roberto Mansfield [EMAIL PROTECTED] wrote: Shelley wrote: Hi all, I made a post a week ago to ask for the idea of the fastest way to get table records. Fyi, http://phparch.cn

Re: [PHP-DB] Table optimization ideas needed

Thank you very much, Chris. :) Fyi, On Wed, Mar 26, 2008 at 1:27 PM, Chris [EMAIL PROTECTED] wrote: Shelley wrote: +--+---+--+-+---++ | Field| Type | Null | Key | Default | Extra

Re: [PHP-DB] Table optimization ideas needed

. -- Postgresql php tutorials http://www.designmagick.com/ -- Regards, Shelley

Re: [PHP-DB] Re: Table optimization ideas needed

). Thanks. -- Postgresql php tutorials http://www.designmagick.com/ -- Regards, Shelley

Re: [PHP-DB] Table optimization ideas needed

but the insert failed in all case). -- Postgresql php tutorials http://www.designmagick.com/ -- Regards, Shelley

Re: [PHP-DB] Table optimization ideas needed

slaves running. Great. Thank you. Thank you for all your help. -- Postgresql php tutorials http://www.designmagick.com/ -- Regards, Shelley

[PHP-DB] Best practices for using MySQL index

time the table will hold millions of records. So the query and index optimization is very important. Any suggestion will be greatly appreciated. -- Regards, Shelley

[PHP-DB] Re: [PHP] Best practices for using MySQL index

On Wed, Apr 30, 2008 at 5:14 PM, Aschwin Wesselius [EMAIL PROTECTED] wrote: Shelley wrote: Hi all, I am currently responsible for a subscription module and need to design the DB tables and write code. I have described my table design and queries in the post: http://phparch.cn

[PHP-DB] Re: [PHP] Best practices for using MySQL index

On Wed, Apr 30, 2008 at 7:03 PM, Aschwin Wesselius [EMAIL PROTECTED] wrote: Shelley wrote: Don't index just all integer fields. Keep track of the cardinality of a column. If you expect a field to have 100.000 records, but with only 500 distinct values it has no use to put an index

[PHP-DB] int(1) and int(11)

Hi all, Is there any difference between int(1) and int(11) when creating a table? I checked the mysql manual and got that 1 and 11 are used to specify the display width of an column. Is there any other difference? Any ideas appreciated. Thx. -- With best regards, Shelley Shyan http

[PHP-DB] rtrim a string with MySQL's function

, 123; 456789, 456789; Is there a faster way to manage that? The faster, the better. :) Thank you for your consideration and waiting for your answer. :) Regards, Shelley -- PHP Database Mailing List