Forum Replies Created

Viewing 3 replies - 1 through 3 (of 3 total)
  • I some cases ISPs won’t be willing to change this setting. If you’re on a Linux host with Apache and “AllowOverride Options” set for your domain you can add this to your .htaccess file:

    <FilesMatch “\.(php|html?)$”>
    php_value memory_limit 16M
    </FilesMatch>

    You may also try adding this to wp-config.php if the above does not work:

    ini_set ( “memory_limit”, “16M”);

    Forum: Plugins
    In reply to: PostsInCategory 1669 limit?
    Thread Starter HappyD

    (@happyd)

    Michael, Thank you for your reply. The link in the source is http://www.sns.ias.edu/~cjm/wp/wordpress/posts-in-category/, but it no longer works, though this guy’s main page still does. It’s a plug in we’ve been using on a few sites for a few years, it may no longer be maintained? I have not had an issue before, but also don’t have another site that has 1000+ posts in one category. I emailed the author last night and he replied with:

    “Ken-

    It must besome limitation of the WordPress DB connection – I am just guessing here. Maybe there is a master configuration file in WordPress that limits max query size.. let me know if you find anything.

    -Chris”

    I checked into wp-includes/functions.php for “function get_posts” and did not see anything obvious. There is a limit clause in the SQL code, but the limit seems to be r[‘offset’],r[‘numberposts’], which numberposts seems to be grabbing the correct total.

    I’ve removed the oracle error code entries for another unrelated reason, but will be running my dump script to add them back in again tonight when I can work on it some more. I suppose it could be my style sheet? I’ve been slowly fixing other issues in my custom theme.

    With a shared host you’re not going to notice a difference either way. Row locking is going to happen on the table level, so your transactions on one table are not often going to effect transactions on another. In a higher traffic situation where you had more direct control of the RDBMS setup you could create that database separation and place the actual database data files on separate disks to lower IO load between them however, in which case you would notice a difference in performance. The level of performance change is really going to depend on how many transactions your RDBMS is doing and what type of storage you have though.

Viewing 3 replies - 1 through 3 (of 3 total)