|
Is there a difference between the following queries, assuming there is a primary field 'id' in the table (as in speed, etc)?
SELECT COUNT(id) FROM table
vs.
SELECT COUNT(*) FROM table
Started by James Simpson on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
But....
Have a look at Count(*) vs Count(col) at www.mysqlperformanceblog.com, they discuss this topicNot in MySQL, no, it has optimized the COUNT well (assuming that your id field is already a PK --which is fairly self-describing).
|
|
Mod Name: Disable total topic and post count to be counted for index
phpBB Version: would be made for 3.0.10
Mod Idea:
Hello,
I think this would be a very neat and useful mod to have. Why?
Most forums got a hidden trash can or staff discussion forum. ...
Started by by Max Pen on
, 4 posts
by 3 people.
Answer Snippets (Read the full thread at phpbbcommunities):
&t=2149490 She said she was feeling generous lol! Anyways I bless her... .
Seems someone has decided to pick up the request and create the mod: http://www.phpbb.com/community/viewtopi .. .
Nice Idea Max,
But is it worth the work and troubles of creating one .
|
|
Alright, so this idea was started in the Feedback section and I've decided it pertinent that I start a petition to clean up the town names!
Here's what I had posted earlier:
Quote: : Seriously, I'm getting so fed up with seeing topics like, "bi/les only...
Started by Jade Gears on
, 11 posts
by 7 people.
Answer Snippets (Read the full thread at gaiaonline):
Report this town topic" Bumpin' it up~ HEY ARI I AGREE WITH U! I HATE PEOPLE WITH THOSE NAMES!!! I MEAN.
|
Ask your Facebook Friends
|
Showing thumbnails in showcase and featured section:
http://www.java-gaming.org/boards/showcase/2/view.html http://www.java-gaming.org/boards/featured/60/view.html It picks the first image of the first post. Feel free to adjust your threads with this ...
Started by Riven on
, 30 posts
by 13 people.
Answer Snippets (Read the full thread at java-gaming):
I guess the author can.
I guess the author However, I did notice that some of the topic images have been scaled poorly.
Indeed!
However, I did notice that some of the topic images have been scaled poorly.
|
|
You guys need to admit this is just a general discussion forum with "some" FE content. And yes I will keep defending BB. Like you even more now that you are vigorously defending yourself BB. LOL
Started by Mario428 on
, 39 posts
by 23 people.
Answer Snippets (Read the full thread at network54):
This-If you don't like the topic,don't click on it and that way,you don't post stupid things and we have one is the overall "king" of off topic threads and (useless) responses on the FE forum, even though he.
|
|
No post count/Disabling post count on a particular forum by Waddle50008 on July 16th 2007, 8:00 am
I suggest their Be a button in options that you can choose that will disable the post count for users so that when a users posts something, their "Posts...
Answer Snippets (Read the full thread at forumotion):
Here if you post in this forum, the post count will not change
I LOVERe: No post count/Disabling post count on a particular forum by skorpy on July 16th 2007, 8:30 am
Personally,I like the ....
Will grow as you post
Off-Topic.
|
|
A major problem that I have with a phpBB forum is that bots, spammers, crawlers, and other scripts keep bumping the view count. For a board I just started I already have a view counts of a few hundreds. It makes no sense. When a script that tries to harvest...
Started by xsawyerx on
, 5 posts
by 4 people.
Answer Snippets (Read the full thread at phpbb):
This makes the view count actually damaging for some, and I've found others who unless you're registered and....
You may want a count of "views by people with certain intentions" but generally *viewing the website*.
counts as a view.
|
|
The vote is over, post count will remain in G&OR.
Original Post:
I'll keep this short if I can, it's one of the biggest debates that's occurred on the forum, and the staff have decided to take your input on this:
Should post count be disabled for G&OR...
Started by Bonkenhi on
, 20 posts
by 18 people.
Answer Snippets (Read the full thread at marriland):
With Divock (Current chapter count: 2)
Extended Signatoor
ASBL
Pokemon total: 12
W: 25 / L: 5 / D: 1 I vote chapter count: 2)
Extended Signatoor
ASBL
Pokemon total: 12
W: 25 / L: 5 / D: 1 I feel bad saying have yet another board with inane....
|
|
I'm archiving this web forum, which normally gets purged about once a week. So I'm screen scraping it, and storing it into my database (PostgreSQL).
I also do a little analysis on the data, with some graphs for users to enjoy, like what time of day is...
Started by Luka on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Name), count(*) FROM posts GROUP BY user_id
also could use having count > 0 so you only return.
|
|
I would like to develop a Forum from scratch, with special needs and customization.
I would like to prepare my forum for intensive usage and wondering how to cache things like User posts count and User replies count.
Having only three tables, tblForum...
Started by pixel3cs on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Tbl prefixes suck -- as much.
Will optimaze that stuff and COUNT(*) will run in ticks...
|
