Re: [PHP-DB] showing warnings
mysql explain SELECT Tune_Name,Tune_Type FROM Mobile_Tunes; +--+--+---+--+-+--+--+---+ | table| type | possible_keys | key | key_len | ref | rows | Extra | +--+--+---+--+-+--+--+---+ | Mobile_Tunes | ALL | NULL | NULL |NULL | NULL |4 | | +--+--+---+--+-+--+--+---+ 1 row in set (0.00 sec) mysql This shows you have NO indexes on the table. Assuming that 'Tune_Name' contains unique entries for each row, I'd suggest you do the following as a minimum: ALTER TABLE Mobile_Tunes ADD PRIMARY KEY (Tune_Name); -- Niel Archer -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] showing warnings
On 9/11/07, Niel Archer [EMAIL PROTECTED] wrote: mysql explain SELECT Tune_Name,Tune_Type FROM Mobile_Tunes; +--+--+---+--+-+--+--+---+ | table| type | possible_keys | key | key_len | ref | rows | Extra | +--+--+---+--+-+--+--+---+ | Mobile_Tunes | ALL | NULL | NULL |NULL | NULL |4 | | +--+--+---+--+-+--+--+---+ 1 row in set (0.00 sec) mysql This shows you have NO indexes on the table. Assuming that 'Tune_Name' contains unique entries for each row, I'd suggest you do the following as a minimum: ALTER TABLE Mobile_Tunes ADD PRIMARY KEY (Tune_Name); How's that going to help if he's getting all records from the table? Also there's no way a database is going to use an index if there are only 4 rows in the table. -- Postgresql php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] showing warnings
This shows you have NO indexes on the table. Assuming that 'Tune_Name' contains unique entries for each row, I'd suggest you do the following as a minimum: ALTER TABLE Mobile_Tunes ADD PRIMARY KEY (Tune_Name); How's that going to help if he's getting all records from the table? Depends what you mean by help. Improve performance of the query, not at all, but that wasn't the original question. In a previous post he said he'd added indexes which his EXPLAIN output clearly shows is not the case. That is simply an example of how to add a PRIMARY KEY after creating the table. However, it will stop duplicate entries from being entered and prepare the way for when he's NOT selecting all rows, so is not entirely wasted. Also there's no way a database is going to use an index if there are only 4 rows in the table. True, but if it was only ever going to have 4 entries in it I doubt he'd be using a Db at all. I'm assuming this is just a sample. -- Niel Archer -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] showing warnings
Hi i am including table structure and other results to you CREATE TABLE Mobile_Tunes ( Tune_ID int(6) NOT NULL AUTO_INCREMENT, Tune_Name varchar(30) NOT NULL, Tune_Type varchar(10) NOT NULL, PRIMARY KEY (Tune_ID), UNIQUE KEY Tune_Name (Tune_Name), INDEX Tune_Type (Tune_Type) )ENGINE=MyISAM; mysql desc mobile_tunes; +---+-+--+-+-++ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-++ | Tune_ID | int(6) | | PRI | NULL| auto_increment | | Tune_Name | varchar(30) | | UNI | || | Tune_Type | varchar(10) | | MUL | || +---+-+--+-+-++ 3 rows in set (0.03 sec) mysql explain select Tune_name, tune_type from mobile_tunes; +--+--+---+--+-+--+--+---+ | table| type | possible_keys | key | key_len | ref | rows | Extra | +--+--+---+--+-+--+--+---+ | mobile_tunes | ALL | NULL | NULL |NULL | NULL |4 | | +--+--+---+--+-+--+--+---+ 1 row in set (0.02 sec) mysql select Tune_name, tune_type from mobile_tunes; +---+---+ | Tune_name | tune_type | +---+---+ | pakistani | midi | | pakistan2 | midi | | usa | midi | | uk| midi | +---+---+ 4 rows in set (0.01 sec) ISSUED WARNINGS Warning: mysql_query(): Your query requires a full tablescan (table Mobile_Tunes, 4 rows affected). Use EXPLAIN to optimize your query. in D:\Program Files\Apache Group\Apache2\htdocs\Breez\mtunes_main.php on line 47 Warning: mysql_query(): Your query requires a full tablescan (table Mobile_Tunes, 4 rows affected). Use EXPLAIN to optimize your query. in D:\Program Files\Apache Group\Apache2\htdocs\Breez\mtunes_main.php on line 70 this table will be populated with at least 60,000 records. these 4 records are just for testing purpose. so if you can tell me what to do to avoid this warning, then it will be great help for me. Bye Niel Archer [EMAIL PROTECTED] wrote: This shows you have NO indexes on the table. Assuming that 'Tune_Name' contains unique entries for each row, I'd suggest you do the following as a minimum: ALTER TABLE Mobile_Tunes ADD PRIMARY KEY (Tune_Name); How's that going to help if he's getting all records from the table? Depends what you mean by help. Improve performance of the query, not at all, but that wasn't the original question. In a previous post he said he'd added indexes which his EXPLAIN output clearly shows is not the case. That is simply an example of how to add a PRIMARY KEY after creating the table. However, it will stop duplicate entries from being entered and prepare the way for when he's NOT selecting all rows, so is not entirely wasted. Also there's no way a database is going to use an index if there are only 4 rows in the table. True, but if it was only ever going to have 4 entries in it I doubt he'd be using a Db at all. I'm assuming this is just a sample. -- Niel Archer -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php Asim Jamil - 0092 345 4025907, Pakistan - Catch up on fall's hot new shows on Yahoo! TV. Watch previews, get listings, and more!
Re: [PHP-DB] showing warnings
Hi
i have added index on both columns but still same warning is issued by mysql
then what i do now
John Mertic [EMAIL PROTECTED] wrote:
Is the table 'Mobile_Tunes' indexed at all? If not, you may want to
consider adding one at least one 'Tune_Type' and another on
'Tune_Name'.
John
On 9/10/07, Asim wrote:
Hi
script is following
if(isset($_GET['SearchTune']))
{
$tunename = substr($_GET['tune_name'],0,3);
$tunetype = $_GET['tune_type'];
$sql = SELECT Tune_Name,Tune_Type FROM Mobile_Tunes WHERE Tune_Name LIKE
'.$tunename.%' AND Tune_Type = '.$tunetype.';
}
else
{
$sql = SELECT Tune_Name,Tune_Type FROM Mobile_Tunes;
}
...
function
max_page($sql,$total_rows,$rows_per_page,$max_pages)
{
$all_rs = mysql_query($sql);
if(!$all_rs)
{
echo Sorry! Try again.;
return false;
}
$total_rows = mysql_num_rows($all_rs);
mysql_free_result($all_rs);
//mysql_close($link);
$max_pages = ceil($total_rows/$rows_per_page);
return $max_pages;
}
when i use this function it shows following warning
Warning: mysql_query(): Your query requires a full tablescan (table
Mobile_Tunes, 5 rows affected). Use EXPLAIN to optimize your query. in
D:\Program Files\Apache
Group\Apache2\htdocs\Breez\mtunes_main.php on line 47
now can you tell me some solution
bye
John Mertic wrote:
Can you provide the script you are running and the exact error message
you are getting?
John
On 9/9/07, Asim wrote:
Hi
in my script when i scan whole table for result set to display in my page
it shows warning that suggest me to use
EXPLAIN statement but i donot need it as i have to show records on page
how to avoid this warning?
Bye
Asim Jamil - 0092 345 4025907, Pakistan
-
Be a better Globetrotter. Get better travel answers from someone who
knows.
Yahoo! Answers - Check it out.
--
--
John Mertic Explaining a joke
is like dissecting a frog: you
[EMAIL PROTECTED] understand it better,
but the frog dies in the
process.
-Mark Twain
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Asim Jamil - 0092 345 4025907, Pakistan
Be a better Heartthrob. Get better relationship answers from someone who
knows.
Yahoo! Answers - Check it out.
--
--
John Mertic Explaining a joke
is like dissecting a frog: you
[EMAIL PROTECTED] understand it better,
but the frog dies in the
process.
-Mark Twain
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Asim Jamil - 0092 345 4025907, Pakistan
-
Looking for a deal? Find great prices on flights and hotels with Yahoo!
FareChase.
Re: [PHP-DB] showing warnings
Hi
i have added index on both columns but still same warning is issued by mysql
then what i do now?
BYE
John Mertic [EMAIL PROTECTED] wrote:
Is the table 'Mobile_Tunes' indexed at all? If not, you may want to
consider adding one at least one 'Tune_Type' and another on
'Tune_Name'.
John
On 9/10/07, Asim wrote:
Hi
script is following
if(isset($_GET['SearchTune']))
{
$tunename = substr($_GET['tune_name'],0,3);
$tunetype = $_GET['tune_type'];
$sql = SELECT Tune_Name,Tune_Type FROM Mobile_Tunes WHERE Tune_Name LIKE
'.$tunename.%' AND Tune_Type = '.$tunetype.';
}
else
{
$sql = SELECT Tune_Name,Tune_Type FROM Mobile_Tunes;
}
...
function
max_page($sql,$total_rows,$rows_per_page,$max_pages)
{
$all_rs = mysql_query($sql);
if(!$all_rs)
{
echo Sorry! Try again.;
return false;
}
$total_rows = mysql_num_rows($all_rs);
mysql_free_result($all_rs);
//mysql_close($link);
$max_pages = ceil($total_rows/$rows_per_page);
return $max_pages;
}
when i use this function it shows following warning
Warning: mysql_query(): Your query requires a full tablescan (table
Mobile_Tunes, 5 rows affected). Use EXPLAIN to optimize your query. in
D:\Program Files\Apache
Group\Apache2\htdocs\Breez\mtunes_main.php on line 47
now can you tell me some solution
bye
John Mertic wrote:
Can you provide the script you are running and the exact error message
you are getting?
John
On 9/9/07, Asim wrote:
Hi
in my script when i scan whole table for result set to display in my page
it shows warning that suggest me to use
EXPLAIN statement but i donot need it as i have to show records on page
how to avoid this warning?
Bye
Asim Jamil - 0092 345 4025907, Pakistan
-
Be a better Globetrotter. Get better travel answers from someone who
knows.
Yahoo! Answers - Check it out.
--
--
John Mertic Explaining a joke
is like dissecting a frog: you
[EMAIL PROTECTED] understand it better,
but the frog dies in the
process.
-Mark Twain
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Asim Jamil - 0092 345 4025907, Pakistan
Be a better Heartthrob. Get better relationship answers from someone who
knows.
Yahoo! Answers - Check it out.
--
--
John Mertic Explaining a joke
is like dissecting a frog: you
[EMAIL PROTECTED] understand it better,
but the frog dies in the
process.
-Mark Twain
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Asim Jamil - 0092 345 4025907, Pakistan
-
Take the Internet to Go: Yahoo!Go puts the Internet in your pocket: mail, news,
photos more.
Re: [PHP-DB] showing warnings
Run the query through MySQL directly prepending EXPLAIN to the query
and attach the results here.
John
On 9/10/07, Asim [EMAIL PROTECTED] wrote:
Hi
i have added index on both columns but still same warning is issued by mysql
then what i do now
John Mertic [EMAIL PROTECTED] wrote:
Is the table 'Mobile_Tunes' indexed at all? If not, you may want to
consider adding one at least one 'Tune_Type' and another on
'Tune_Name'.
John
On 9/10/07, Asim wrote:
Hi
script is following
if(isset($_GET['SearchTune']))
{
$tunename = substr($_GET['tune_name'],0,3);
$tunetype = $_GET['tune_type'];
$sql = SELECT Tune_Name,Tune_Type FROM Mobile_Tunes WHERE Tune_Name LIKE
'.$tunename.%' AND Tune_Type = '.$tunetype.';
}
else
{
$sql = SELECT Tune_Name,Tune_Type FROM Mobile_Tunes;
}
...
function
max_page($sql,$total_rows,$rows_per_page,$max_pages)
{
$all_rs = mysql_query($sql);
if(!$all_rs)
{
echo Sorry! Try again.;
return false;
}
$total_rows = mysql_num_rows($all_rs);
mysql_free_result($all_rs);
//mysql_close($link);
$max_pages = ceil($total_rows/$rows_per_page);
return $max_pages;
}
when i use this function it shows following warning
Warning: mysql_query(): Your query requires a full tablescan (table
Mobile_Tunes, 5 rows affected). Use EXPLAIN to optimize your query. in
D:\Program Files\Apache
Group\Apache2\htdocs\Breez\mtunes_main.php on line 47
now can you tell me some solution
bye
John Mertic wrote:
Can you provide the script you are running and the exact error message
you are getting?
John
On 9/9/07, Asim wrote:
Hi
in my script when i scan whole table for result set to display in my
page
it shows warning that suggest me to use
EXPLAIN statement but i donot need it as i have to show records on page
how to avoid this warning?
Bye
Asim Jamil - 0092 345 4025907, Pakistan
-
Be a better Globetrotter. Get better travel answers from someone who
knows.
Yahoo! Answers - Check it out.
--
--
John Mertic Explaining a joke
is like dissecting a frog: you
[EMAIL PROTECTED] understand it better,
but the frog dies in the
process.
-Mark Twain
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Asim Jamil - 0092 345 4025907, Pakistan
Be a better Heartthrob. Get better relationship answers from someone who
knows.
Yahoo! Answers - Check it out.
--
--
John Mertic Explaining a joke
is like dissecting a frog: you
[EMAIL PROTECTED] understand it better,
but the frog dies in the
process.
-Mark Twain
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Asim Jamil - 0092 345 4025907, Pakistan
Looking for a deal? Find great prices on flights and hotels with Yahoo!
FareChase.
--
--
John MerticExplaining a joke
is like dissecting a frog: you
[EMAIL PROTECTED] understand it better,
but the frog dies in the
process.
-Mark Twain
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] showing warnings
Hi
this result is shown by mysql on running command prompt
mysql explain SELECT Tune_Name,Tune_Type FROM Mobile_Tunes;
+--+--+---+--+-+--+--+---+
| table| type | possible_keys | key | key_len | ref | rows |
Extra |
+--+--+---+--+-+--+--+---+
| Mobile_Tunes | ALL | NULL | NULL |NULL | NULL |4 |
|
+--+--+---+--+-+--+--+---+
1 row in set (0.00 sec)
mysql
and
mysql SELECT Tune_Name,Tune_Type FROM Mobile_Tunes;
+---+---+
| Tune_Name | Tune_Type |
+---+---+
| pakistani | midi |
| pakistan2 | midi |
| usa | midi |
| uk| midi |
+---+---+
4 rows in set (0.00 sec)
mysql
now what next?
bye
John Mertic [EMAIL PROTECTED] wrote: Run the query through MySQL directly
prepending EXPLAIN to the query
and attach the results here.
John
On 9/10/07, Asim wrote:
Hi
i have added index on both columns but still same warning is issued by mysql
then what i do now
John Mertic wrote:
Is the table 'Mobile_Tunes' indexed at all? If not, you may want to
consider adding one at least one 'Tune_Type' and another on
'Tune_Name'.
John
On 9/10/07, Asim wrote:
Hi
script is following
if(isset($_GET['SearchTune']))
{
$tunename = substr($_GET['tune_name'],0,3);
$tunetype = $_GET['tune_type'];
$sql = SELECT Tune_Name,Tune_Type FROM Mobile_Tunes WHERE Tune_Name LIKE
'.$tunename.%' AND Tune_Type = '.$tunetype.';
}
else
{
$sql = SELECT Tune_Name,Tune_Type FROM Mobile_Tunes;
}
...
function
max_page($sql,$total_rows,$rows_per_page,$max_pages)
{
$all_rs = mysql_query($sql);
if(!$all_rs)
{
echo Sorry! Try again.;
return false;
}
$total_rows = mysql_num_rows($all_rs);
mysql_free_result($all_rs);
//mysql_close($link);
$max_pages = ceil($total_rows/$rows_per_page);
return $max_pages;
}
when i use this function it shows following warning
Warning: mysql_query(): Your query requires a full tablescan (table
Mobile_Tunes, 5 rows affected). Use EXPLAIN to optimize your query. in
D:\Program Files\Apache
Group\Apache2\htdocs\Breez\mtunes_main.php on line 47
now can you tell me some solution
bye
John Mertic wrote:
Can you provide the script you are running and the exact error message
you are getting?
John
On 9/9/07, Asim wrote:
Hi
in my script when i scan whole table for result set to display in my
page
it shows warning that suggest me to use
EXPLAIN statement but i donot need it as i have to show records on page
how to avoid this warning?
Bye
Asim Jamil - 0092 345 4025907, Pakistan
-
Be a better Globetrotter. Get better travel answers from someone who
knows.
Yahoo! Answers - Check it out.
--
--
John Mertic Explaining a joke
is like dissecting a frog: you
[EMAIL PROTECTED] understand it better,
but the frog dies in the
process.
-Mark Twain
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Asim Jamil - 0092 345 4025907, Pakistan
Be a better Heartthrob. Get better relationship answers from someone who
knows.
Yahoo! Answers - Check it out.
--
--
John Mertic Explaining a joke
is like dissecting a frog: you
[EMAIL PROTECTED] understand it better,
but the frog dies in the
process.
-Mark Twain
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Asim Jamil - 0092 345 4025907, Pakistan
Looking for a deal? Find great prices on flights and hotels with Yahoo!
FareChase.
--
--
John Mertic Explaining a joke
is like dissecting a frog: you
[EMAIL PROTECTED] understand it better,
but the frog dies in the
process.
-Mark Twain
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Asim Jamil - 0092 345 4025907, Pakistan
-
Tonight's top picks. What will you watch tonight? Preview the hottest shows on
Yahoo! TV.
Re: [PHP-DB] showing warnings
Asim wrote: Hi in my script when i scan whole table for result set to display in my page it shows warning that suggest me to use EXPLAIN statement but i donot need it as i have to show records on page how to avoid this warning? Bye Asim Jamil - 0092 345 4025907, Pakistan - Shape Yahoo! in your own image. Join our Network Research Panel today! If it is a PHP Warning you could use error_reporting() http://www.php.net/manual/en/function.error-reporting.php If it is a DB Warning you should seek how to control the Warnings|Errors, depending on the DB look for the error functions. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
