Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.php > #1932

Re: Storing parsed XML-elements as blobs

Cross-posted to 2 groups.

Show all headers | View raw

On 5/30/2011 2:42 AM, Maccabi wrote:
> Hello!
>
> I am looking for an efficient way of storing large amounts of data in
> mysql, so that it is quick to access and efficient in store. Im using
> PHP.
>
> One idea I am playing with, is parsing (deserializing) the elements
> and saving the DOMElements (in their binary existience) as BLOBS to be
> retrieved and parsed for different type of contained data when
> necessary.
>
> One danger I see is that in this way I am "bound" to a platform. I
> guess Java or Perl programs on the same platform, or even PHP program
> on a different platform, will not be able to utilize the data (is this
> really the case, BTW?).
>
> The question is: is it really as efficient as I imagine it to be?
> could the efficiency outweigh the disadvantages?
>
> The alternative is to store the XML element as a serialized string,
> deserialize it at retrieve time, and analyzing / extracting /
> modifying before re-storing as a string.
>
> Any experience / know-how out there?
>
> Thanks a lot!
>
> Michael
>

Impossible to tell from your description.  The best way to save data is 
almost always based on what the data is.

Personally, I don't save DOM elements or XML in MySQL.  I save the data.

-- 
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

Back to comp.lang.php | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Storing parsed XML-elements as blobs Maccabi <norway.maccabi@gmail.com> - 2011-05-29 23:42 -0700
  Re: Storing parsed XML-elements as blobs Jerry Stuckle <jstucklex@attglobal.net> - 2011-05-30 08:57 -0400
    Re: Storing parsed XML-elements as blobs Mathieu Maes <mathieu@webberig.be> - 2011-05-30 07:57 -0700
  Re: Storing parsed XML-elements as blobs Axel Schwenke <axel.schwenke@gmx.de> - 2011-05-30 20:10 +0200

csiph-web