Re: OO DB in PHP?
| From: | Greg Donald | Date: | Thu, 02 Jun 2005 16:55:22 +0000 |
| Subject: | Re: OO DB in PHP? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-216247@lists.php.net to get a copy of this message | ||
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
database, 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/