1d
comment Is performance worse when putting database to a dedicated server?
"DBs should not be bothered with complex requests involving multiple tables. Simple requests filtered by the client is the way to go." I may be misunderstanding, but I strongly disagree. In my experience, it's best to do as much work as possible in the DB. Heck, it's designed for handling complex queries. Moving joining/filtering "up" a level to the application, in my experience, slows things down greatly.
Oct
17
comment Reload browser window after POST without prompting user to resend POST data
Funny how this apparently doesn't do what it's supposed to do, yet people visiting this page keep up voting it... Maybe people come to this page attempting to do the opposite of what the OP intended? (e.g. "reload" the page and omit POST parameters)
Oct
13
awarded Notable Question
Oct
9
comment With "magic quotes" disabled, why does PHP/Wordpress continue to auto-escape my POST data?
Also note @quickshiftin's excellent answer as a nice alternative.
Oct
9
comment With "magic quotes" disabled, why does PHP/Wordpress continue to auto-escape my POST data?
@AlexanderO'Mara: Thanks for your warning! One workaround to this would simply be to not overwrite the original superglobals. Instead, one could use separate, regular arrays like $post, $get, etc. (e.g. $post = array_map('stripslashes_deep', $_POST);)
Oct
7
comment What to use instead of apc user data cache in php 5.5?
Thanks, @ArturBodera! I think it goes either way - I think there's a setting somewhere to specify whether to use the original names or the APCu versions. Regardless, the original nomenclature is working well for me now, so I'll stick with it! :)
Oct
6
comment What to use instead of apc user data cache in php 5.5?
When migrating from APC to APCu, doesn't apc_store() become apcu_store() (etc)?
Oct
4
awarded Popular Question
Oct
1
comment Max tables in a MySQL database
For what it's worth, I currently manage a Wordpress Multisite installation with about 7,000 sites in it. That equates to 63,000 tables. There are unique challenges with managing a large network like this, but it's certainly very possible.
Oct
1
comment The maximum number of tables in a single database
For what it's worth, I currently manage a Wordpress Multisite installation with about 7,000 sites in it. That equates to 63,000 tables. There are unique challenges with managing a large network like this, but it's certainly very possible. Regardless, the advice is still sound - before adding more tables, you should consider if there's an alternative architecture that doesn't require so much database bloat.
Oct
1
comment Maximum Number of Tables in MySQL
For what it's worth, I currently manage a Wordpress Multisite installation with about 7,000 sites in it. That equates to 63,000 tables. There are unique challenges with managing a large network like this, but it's certainly very possible.
Sep
17
awarded Yearling
Sep
11
awarded Notable Question
Sep
6
comment Replace URLs in text with HTML links
Hi, @SørenLøvborg! I made some upgrades to your code and submitted a Pull Request - hope it works well for you! :) bitbucket.org/rinogo/urllinker/overview
Sep
1
awarded Popular Question
Aug
26
comment Photoshop Batch Action Save for Web and Devices
If you work on a file that's already open, you don't need to include the extra step of "[deleting] the first part of action Open File"
Aug
19
comment Can I "add friend" with Facebook's API?
This doesn't work anymore.
Aug
19
comment Can I "add friend" with Facebook's API?
We used this solution for quite some time. Alas, with v2.0 of the Graph API, Facebook has deprecated it. (It no longer works) I have no recommendation on an alternative approach.
Aug
19
comment Facebook Friend Dialog Replacement
Just got bitten by this today. If anyone has any ideas, I'd love to hear them! The best I've come up with so far is to provide instructions to a user regarding how to add a friend on Facebook, and linking to the desired friend's profile, hoping the user figures it out. How is this an improvement in UX, Facebook?
Aug
13
awarded Scholar
1 2 3 4 5