|
|
Posted by Greg Donald on 06/02/05 19:55
On 6/2/05, GamblerZG <gambler@highstream.net> wrote:
> When you have objects stored on disk, it's usually very convenient to
> read them on demand. However, MySQL is clearly not meant for this
> purpose.
A serialized PHP object is just a string of data. MySQL is a very
fast `data`base, so I don't quite understand this statement.
> Query overhead, complexity of SQL needed, and some other
> limitation make object storage and retrieval a headache.
Did you have some code that you need help debugging?
> The question is, is it possible to write reasonably efficient OO
> database in php?
I don't use objects in web applications. In my experience the
overhead involved in creating an object for the extremely short
lifetime it has is overkill.
> Two main factors would be:
> 1) Is is possible to make fast B-tree index search without writing any C
> code?
MySQL supports btree indexes for MyISAM and InnoDB table types.
> 2)How long does it takes for PHP to open 1 file? (It will need to open
> hundreds of them.)
Depends on your hardware, not so much PHP.
--
Greg Donald
Zend Certified Engineer
http://destiney.com/
Navigation:
[Reply to this message]
|