Quote:
Clearly that's not a good answer but a count of the number of rows without the WHERE clause should work...
NO. maybe i forgot to mention clearly in my last post but I have 500 error and memory limit with the simple query too.
SELECT COUNT(*) FROM `bb_posts`;
Now i reach to this conclusion that limiting the number of results
by adding WHERE will solve the issue.
for example i dont have error when count a user posts:
SELECT COUNT(*) FROM `bb_posts` WHERE (uid = '1')
But maybe im still wrong.
I can give you more information about the table maybe it can help.
Table bb_posts Size is about 39MB and Rows are about 174,000
also I dont have any issue when i run the count query in phpmyadmin.
Quote:
What keys do you have on the bb_posts table?
you can find all tables in newbb module.
CREATE TABLE `bb_posts` (
`post_id` int(10) unsigned NOT NULL auto_increment,
`pid` int(10) unsigned NOT NULL default '0',
`topic_id` int(8) unsigned NOT NULL default '0',
`forum_id` smallint(4) unsigned NOT NULL default '0',
`post_time` int(10) unsigned NOT NULL default '0',
`uid` int(10) unsigned NOT NULL default '0',
`poster_name` varchar(255) NOT NULL default '',
`poster_ip` int(11) NOT NULL default '0',
`subject` varchar(255) NOT NULL default '',
`icon` varchar(25) NOT NULL default '',
`attachsig` tinyint(1) unsigned NOT NULL default '0',
`approved` smallint(2) NOT NULL default '1',
`post_karma` int(10) unsigned NOT NULL default '0',
`attachment` text,
`require_reply` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`post_id`),
KEY `uid` (`uid`),
KEY `pid` (`pid`),
KEY `forum_id` (`forum_id`),
KEY `topic_id` (`topic_id`),
KEY `subject` (`subject`(40)),
KEY `forumid_uid` (`forum_id`,`uid`),
KEY `topicid_uid` (`topic_id`,`uid`),
KEY `post_time` (`post_time`),
KEY `forumid_approved_postid` (`forum_id`,`approved`,`post_id`),
FULLTEXT KEY `search` (`subject`(64))
) ENGINE=MyISAM;
