Beware of MySQL View Filtering in Your PHP Code
Published October 31st, 2008Why MySQL VIEW filtering (i.e. applying WHERE clause) might be a bad for performance.
|
|
|
|
| CA | BD | NY |
Categories
Recent Posts
User Services
Blogroll
Apache Hacker
- Running Apache with PHP5 and PHP4 modules on the Same Linux Server
- Quick and Dirty Apache Bandwidth Report Hack in Perl
- Disabling SSL v2 in Apache/SSL
- Quick and Dirty Apache Log Analyzer to Find Top-100 IP Visits
- Output Filtering Using PHP
- Compiling Apache with Old Version of APR Utils…
- Another 64-bit Headache Installing Apache on CentOS 5.3
- Setting up a PHP Filter for a Directory Alias
- Writing a Custom Apache Log File Using a PHP Script in Real Time
- Using Awk to do Quick and Dirty Analysis of Apache Logs
CentOS Hacker
- What a Difference Diff Can Make!
- Quick and Dirty Monitoring Tool
- Stop Lock Files from Locking Your Cron Jobs Upon Unscheduled Reboot
- Creating a swap partition
- Surviving fsck.ext3: Unable to resolve LABEL problem
- Creating SFTP-only User Accounts to Kill SSH Access
- Tuning Postfix to Fight SPAM a Little Better…
- Running out of disk space even when 20% is free!
- Bringing Email Home Across the Globe
- Mounting DVD ISO Files on CentOS 5.3
miniCTO
- minicto: I dare you to ask your software team/consultant if they ever worked on profiling the software or even developed it to have profiling support
- minicto: Optimization considerations should be part of software design and not an after-thought!
- minicto: It is much harder to optimize fully developed software than one in development
- minicto: Many inexperience software engineers think that per Pareto Principle they can easily optimize code by as it relates to 20% of the code.
- minicto: Pareto Principle applied to software engineering states that 80% of the run-time is spent executing 20% of the code.
- minicto: The core discipline of computer security is simple: shut all doors and windows and open only on a as-needed basis under careful watch
- minicto: Computer security risks are not mitigated at one place; they are handled in layers: location, hardware, os, storage, network, API, users
- minicto: Performance tuning is an art that most programmers don't experience in school or early career; its makes or breaks software engineers
- minicto: Nothing beats a whiteboard session with the team when it comes to hashing out ideas, issues and just about anything to do with project mgmt
- minicto: Tweets among like-minded real people would accomplish a lot: understanding, knowledge, connections, and eventually financial transactions
- minicto: I wish most twitter users realized if it becomes an automatic marketing blip ads by everyone to visit shortened links, it would really suck
- minicto: The wikipedia project is a proof that human-generated not automated contents are worth something
- minicto: Most everything (online) thats says FREE has some string attached; e-books for example are often free but in most cases they are sales pitch
- minicto: Online education, awareness, and building trusted, real relationships with real people is key to the success of your business
- minicto: Use fancy technology to con the average men is so low; such bottom-feeders need to be weeded out.
- minicto: It's a shame to see so many people setup online traps to catch the unsuspecting the average Joe by selling things he does not need.
- minicto: Only if people put their creativity to build something new, they would achieve so much more than just trying to confuse others.
- minicto: Micro online business idea #5: Buy and sell existing expired domains on ebay; your mileage will vary. Cost $$$/mon. Income: $$$$/mon
- minicto: Micro online business idea #4: Create and flip informative web sites on specific topics you can compile info on; Cost: $$$/mon; Income: 3-5x
- minicto: Micro online business idea #3: Be an online PR consultant for businesses; offer to dig up testimonials from all online sources. Cost $$$/mn
Our Tweets
- No tweets available at the moment.
- More updates...
