FUDforum: comp.lang.php » Storing parsed XML-elements as blobs

Home » Imported messages » comp.lang.php » Storing parsed XML-elements as blobs

Show: Today's Messages :: Polls :: Message Navigator

Storing parsed XML-elements as blobs [message #174266]

Mon, 30 May 2011 06:42

Maccabi
Messages: 1
Registered: May 2011

Karma:

Junior Member

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

Report message to a moderator

[Message index]

		Storing parsed XML-elements as blobs By: Maccabi on Mon, 30 May 2011 06:42
		Re: Storing parsed XML-elements as blobs By: Jerry Stuckle on Mon, 30 May 2011 12:57
		Re: Storing parsed XML-elements as blobs By: Mathieu Maes on Mon, 30 May 2011 14:57
		Re: Storing parsed XML-elements as blobs By: Axel Schwenke on Mon, 30 May 2011 18:10

Previous Topic:	a more elegant way?
Next Topic:	Print preview in php

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 15:06:44 GMT 2024

Total time taken to generate the page: 0.05487 seconds