Posts Tagged ‘mysql’

How many Queries are too many?

40
responses
by
Mark Ghosh
on
July 12th, 2008
in
Blogging, General, WordPress

I have been asked this question quite a few times and I never have a perfect answer. It is obviously an important question to ask but it can be answered in many different ways based on preferences, need for plugins, optimization techniques used and a variety of other factors.
Weblog Tools Collection uses a lot of plugins and is very query heavy but the in spite of that, the front page uses 59 queries to generate itself. I think the default (on a vanilla WordPress install on the default theme) is 27 or something of that nature. The larger the number of queries, the slower the page is going to load and the more load you are going to put on your MySql server. All of the above is true if you do not use inline or regenerative caching mechanisms. The caveat on this blog is that its plugins and its [...]

[Continue Reading...]

1 Star2 Stars3 Stars4 Stars5 Stars (15 votes, average: 4.27 out of 5)
Loading ... Loading ...

DiggProof your Wordpress

1
response
by
Mark Ghosh
on
January 23rd, 2007
in
Blogging News, WordPress, WordPress Hack

DiggProof your Wordpress A close look at optimizing and tweaking your MySql database for Wordpress and other tips and plugins to make your Wordpress blog faster than it already is. Even though Wordpress is fast in its own right, this article is geared for high traffic blogs and especially those that run Wordpress on smaller Virtual Private Servers.
While we are on the subject of optimizations, the newly released Wordpress 2.1 Ella has introduced many code and query optimizations that should make Wordpress much faster than it already was. For example, one of the changes introduced to handle future posts gives the database the ability to cache more queries at the MySql level and should reduce load on the database server (however minuscule).

[Continue Reading...]

1 Star2 Stars3 Stars4 Stars5 Stars (4 votes, average: 4.50 out of 5)
Loading ... Loading ...

Closed, Open Source Share Compatibility Problems

2
responses
by
Mark Ghosh
on
December 13th, 2005
in
Blogging News, LinkyLoo

Closed, Open Source Share Compatibility Problems: Interesting take on the compatibility problems brought onto Wordpress by the latest versions of Mysql running in “strict” mode as default. Especially poignant here because I see well greased programmers moving to the postgresql model because of a shift of ideologies of the mysql group. I should look into the added benefits that the strict model provides to the system.

[Continue Reading...]

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading ... Loading ...

MYdbPAL Free Download

No
responses
by
Mark Ghosh
on
October 19th, 2005
in
LinkyLoo

MYdbPAL Free Download: I am not sure of this program and you are on your own to figure out how this works but from my initial reaction, though the user interface is hideous, it can be a useful database education tool and provide good insight into existing database schemas. Thanks SlickDeals

[Continue Reading...]

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading ... Loading ...


Obviously Powered by WordPress. © 2003-2010 MidOut LLC

page counter