What happened to the Messenger Plus! forums on msghelp.net?
Shoutbox » MsgHelp Archive » General » Forum & Website » Bug in MsgPluslive.net voting

Bug in MsgPluslive.net voting
Author: Message:
RaceProUK
Elite Member
*****

Avatar

Posts: 6073
Reputation: 57
39 / Male / Flag
Joined: Oct 2003
RE: Bug in MsgPluslive.net voting
quote:
Originally posted by leachy08
You should just store 1 vote as one record in mysql. This will slow things down but shouldnt be that bad.
It will be that bad. Imagine, a few months down the line, several thousand votes have been cast. The query will take far longer to run than collecting all votes into a single record per script.
quote:
Originally posted by leachy08
And as for the download count you could use SELECT DISTINCT statement and count the recordset.
SELECT DISTINCT should only be used where necessary, as again it can slow queries down considerably. Again, with several thousand downloads, maybe even tens or hundreds of thousands, the size of the recordset makes SELECT DISTINCT impractical.
[Image: spartaafk.png]
08-10-2006 08:50 AM
Profile PM Web Find Quote Report
« Next Oldest Return to Top Next Newest »

Messages In This Thread
Bug in MsgPluslive.net voting - by leachy08 on 08-08-2006 at 11:40 AM
RE: Bug in MsgPluslive.net voting - by Menthix on 08-08-2006 at 11:54 AM
RE: Bug in MsgPluslive.net voting - by leachy08 on 08-08-2006 at 02:27 PM
RE: Bug in MsgPluslive.net voting - by Menthix on 08-08-2006 at 10:27 PM
RE: Bug in MsgPluslive.net voting - by leachy08 on 08-09-2006 at 07:50 AM
RE: Bug in MsgPluslive.net voting - by John Anderton on 08-09-2006 at 08:33 AM
RE: Bug in MsgPluslive.net voting - by leachy08 on 08-09-2006 at 08:52 AM
RE: Bug in MsgPluslive.net voting - by NiteMare on 08-09-2006 at 10:57 AM
RE: Bug in MsgPluslive.net voting - by Menthix on 08-09-2006 at 11:10 AM
RE: Bug in MsgPluslive.net voting - by leachy08 on 08-09-2006 at 12:44 PM
RE: Bug in MsgPluslive.net voting - by Menthix on 08-09-2006 at 01:47 PM
RE: Bug in MsgPluslive.net voting - by leachy08 on 08-09-2006 at 02:03 PM
RE: Bug in MsgPluslive.net voting - by Menthix on 08-09-2006 at 02:19 PM
RE: Bug in MsgPluslive.net voting - by leachy08 on 08-09-2006 at 02:37 PM
RE: Bug in MsgPluslive.net voting - by Menthix on 08-09-2006 at 07:50 PM
RE: Bug in MsgPluslive.net voting - by leachy08 on 08-10-2006 at 07:59 AM
RE: Bug in MsgPluslive.net voting - by RaceProUK on 08-10-2006 at 08:50 AM
RE: Bug in MsgPluslive.net voting - by leachy08 on 08-10-2006 at 09:13 AM
RE: Bug in MsgPluslive.net voting - by RaceProUK on 08-10-2006 at 09:53 AM
RE: Bug in MsgPluslive.net voting - by leachy08 on 08-10-2006 at 10:13 AM
RE: Bug in MsgPluslive.net voting - by Menthix on 08-10-2006 at 11:48 AM


Threaded Mode | Linear Mode
View a Printable Version
Send this Thread to a Friend
Subscribe | Add to Favorites
Rate This Thread:

Forum Jump:

Forum Rules:
You cannot post new threads
You cannot post replies
You cannot post attachments
You can edit your posts
HTML is Off
myCode is On
Smilies are On
[img] Code is On