I am only talking about updates. $rb->store().
I don't know how caching plugin works, but I would imagine it is for
reads, not writes.
I don't use journaling system.
There are only 7 tables.
I installed APC and it knocked off about 20-40% of execution time.
Still a regular insert with Redbean takes ~700ms as opposed to
straight PDO ~40ms.
Yikes.
I measured the actual insert time (I/O) by placing metrics in the
QueryWriter, and that comes at ~40ms,
so the other ~600ms+ must come from code execution...which is
incredible. I've worked mostly in Java/JVM and I've never
seen such unfavourable execution to I/O ratio.
I guess I'll run benchmarks on a similar kind of process in a JVM.
It is very possible I am just experiencing a language-shock (seeing
that PHP isn't as great as I thought it was)
So don't take it personally
On Dec 2, 1:51 am, gabor de mooij <
gabordemo...@gmail.com> wrote:
> I recommend to use APC or eAccelerator. We use APC (It makes a lot of
> difference).
> To speed up RedBean you can use the caching plugin, and you can tweak the
> journaling system (if you use it), by filtering unimportant tables. Also try
> some indexes; but only on tables that you need to read more than update;
> cause it slows down your updates.
>
> Are you having RedBean specific performance issues or just PHP?
>
> On Wed, Dec 2, 2009 at 2:32 AM, dkornishev <
danil.kornis...@gmail.com>wrote:
>
> > Ok, looks like I am wrong. Actual I/O takes ~40ms (I placed measuring
> > statements in QueryWriter).
>
> > It seems incredible to me that execution time can go grom 40ms to over
> > 800ms on code alone.
> > I've never seen this happen in Java, but perhaps PHP is different.
> > Perhaps some sort of caching software would help? (i.e. APC)
>
> > On Dec 1, 8:24 pm, dkornishev <
danil.kornis...@gmail.com> wrote:
> > > Well, initially I only benched RedBean for reading...yesterday I was
> > > observing write speed...and was unpleasantly surprised.
>
> > > Today I ran a few tests doing same kind of update/insert using plain
> > > PDO and Redbean and the difference is almost 20 times!
>
> > > I have no idea what could cause it, typically I/O by far dwarfs
> > > execution times.
>
> > --
>
> > You received this message because you are subscribed to the Google Groups
> > "redbeanphp" group.
> > To post to this group, send email to
redbe...@googlegroups.com.
> > To unsubscribe from this group, send email to
> >
redbeanorm+...@googlegroups.com<
redbeanorm%2Bunsu...@googlegroups.com>
> > .