Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - Dragooon
706
Off-topic / Re: MySQL Optimization question
« on September 7th, 2011, 08:09 PM »
There are about 10 fields, I can do that I believe.
707
Off-topic / Re: MySQL Optimization question
« on September 7th, 2011, 07:27 PM »
Device's name. desktop, iphone, ipod, ipad etc.
708
Off-topic / MySQL Optimization question
« on September 7th, 2011, 07:11 PM »
I got a simple table having the following fields

Code: [Select]
id int(11) primary key auto increment
wpm_total int(11)
wpm_effective int(11)
time int(11)
duration int(11)
device varchar(20)

Now if I got a few statistical SQL queries
Code: [Select]
SELECT COUNT(*) AS num, device
FROM scores
GROUP BY device
ORDER BY device_total DESC
Code: [Select]
SELECT (AVG(wpp_effective) / AVG(wpp_total)) AS average
FROM scores
WHERE device = :device
GROUP BY :device
Code: [Select]
SELECT AVG(wpp_effective) AS average
FROM scores
WHERE device = :device
GROUP BY :device

What'd be the best way to optimize it(Indexes, etc) so that it doesn't cause heavy lags(Apart from caching)?


709
Plugins / Re: Mods, support and so on
« on September 6th, 2011, 07:37 PM »
I am answering to the first post, don't have enough time to read all of the posts.

Honestly, all the mods, paid or free, should be hosted on Wedge.org. Free ones shouldn't be moderated but paid ones should be. Apart from this, the package manager should have a better repository browser with support for paid mods, downloading, updating, announcements, etc.

As far as resources goes, a bug tracker, repository(?), documentation.
710
Off-topic / Re: Not really off topic but I'm short on ideas.
« on August 30th, 2011, 07:20 PM »
You got windoozed? Well all I can say is try with another directory, I am out of ideas.
711
Off-topic / Re: Not really off topic but I'm short on ideas.
« on August 30th, 2011, 06:19 PM »
Can you tell the value of sourcedir and addonsdir? And you're positive the directory exists?
712
The Pub / Re: Public repository?
« on August 29th, 2011, 03:11 PM »
Well, that makes sense. Thanks :).
713
The Pub / Public repository?
« on August 29th, 2011, 02:12 PM »
Have you guys thought about it? Most open source projects got a fairly public repository, IMO it would be a nice idea.
714
The Pub / Re: What about mobile?
« on August 28th, 2011, 10:38 AM »
I'd like to wait till SMF4Mobile 1.1 is atleast beta 2-3 before trying it out on Wedge. If you want you can give 1.0 a shot to port.
715
The Pub / Re: What about mobile?
« on August 28th, 2011, 10:20 AM »
I haven't done the port yet because I'm still working on 1.1(It is taking a lot longer because I've been experimenting a lot with different UI ideas and backend scripts). Although if you wanna help go ahead.
716
The Pub / Re: What about mobile?
« on August 28th, 2011, 09:37 AM »
What do you think he referred to here?
Quote from Arantor
and Dragooon has a very nice theme for smartphones that he may decide to add to Wedge's core, but that's totally up to him whether he will or not.
717
Off-topic / Re: IE users are dumb
« on August 27th, 2011, 06:52 PM »
Quote from Arantor on August 27th, 2011, 06:12 PM
Not particularly reliably. Like I said, some stuff will work just fine, some won't and some will be temperamental. A fair amount depends on how it was compiled, stuff compiled from the likes of gcc will likely be more stable and less glitchy, because it's not compiled with Intel specific optimisations for the most part.
That doesn't rule out the fact that it can be done, and many people do run it with enough stability for day to day tasks.
718
Off-topic / Re: IE users are dumb
« on August 27th, 2011, 02:37 PM »
Quote from live627 on August 26th, 2011, 01:43 AM
Quote from Dragooon on August 25th, 2011, 03:13 PM
Not to sound like a fanboy but the reality is exactly the opposite. Mac's use PC hardware, there is hardly anything special about Mac's hardware. It's Mac OS X that actually makes a difference(if any).
Using that logic, I can run OS X on my AMD... nope, doesn't work like that.
Actually, you can.
719
Development blog / Re: Anniwersary
« on August 25th, 2011, 03:40 PM »
On a more serious note, it's great to see the kind of dedication you guys are showing. I can't wait until the show really starts.
720
Off-topic / Re: IE users are dumb
« on August 25th, 2011, 03:21 PM »
Quote from Arantor on August 25th, 2011, 03:18 PM
Quote
Mac's use PC hardware, there is hardly anything special about Mac's hardware.
Well, it is a very specific set of PC hardware, to be precise. It is possible to run OS X on a PC provided that it's an Intel and has similar/same type of graphics and sound attached...
Yes but you can buy off those from the market for half the price combined. You need an 4xxx ATi card or newer and one of newer Intel processors to run Mac on PCs reliably, have done it quite a few times before.