in reply to speed and efficiency XML/DBI vs DBI

do you fellows believe that the wesite would run more efficiently or faster if i were to use the XML, or just go straight from the database?

It is almost always better to cache, unless the mechanism you've chosed for caching is itself expensive. XML is flexible, but it carries some overhead, including the additional modules you need to load at runtime to convert it to HTML. An XML cache is probably going to save substantially over going to the database each time, but you're still leaving some performance opportunities on the table.

Why not cache links in an HTML fragment?

  • Comment on Re: speed and efficiency XML/DBI vs DBI

Replies are listed 'Best First'.
Re: Re: speed and efficiency XML/DBI vs DBI
by primus (Scribe) on Jan 13, 2003 at 19:02 UTC

    well, i was thinking about caching with a regular text, or HTML file, but then i remembered about the prepare_cached() method for the DBI... do you guys think that there would really be a huge difference from using that, to reading say an HTML file...

    the table with the links is not very big and also i will have established a connection to the database for other reasons, so it's not like i need to 'connect' to the database everytime i want to pull the links... i just have to run the SQL query...

[reply]
      it's not like i need to 'connect' to the database everytime i want to pull the links... i just have to run the SQL query...

      It's considerably more expensive to ship a query over the wire, compile it, execute it, then marshal the results to ship back over the wire to an application that then needs to unmarshal those results than it is to open a local file and suck some bytes into memory. Perhaps, though, that performance difference isn't significant in your application.

      A perfectly reasonable approach it to consider the likely upper bound on traffic that your site will need to support, then do the simplest thing that will satisfy that performance requirement. If executing a query (or several queries) per page view works for you, go for it.

[reply]
      The prepare_cached method prevents the statement handle from being created more than once (in a persistent environment like mod_perl), but that's all it does. The query still has to be executed by the database. It should be faster to pull the data from a cache.

      Maybe you're getting ahead of yourself here. Is the site slow now? Have you profiled it to find out where the bottlenecks are? It could be that this particular query runs so fast that it's not worth caching.

[reply]
        well, the site is not slow, i was just looking to the future, because though the site isnt finished,i just wanted to start with the fastest possible execution, avioding any bottleneck before it occurs.

        and yes, i suppose i am getting ahead of myself, because the calls to the database are fairly simple SQL queries, so in all reality i doubt that they will pose a problem... i am just curious as to faster execution possibilities.

        thanks for the wisdom fellow monks
[reply]

In Section Seekers of Perl Wisdom