[geeklog-devtalk] geeklog-devel digest, Vol 1 #470 - 6 msgs

geeklog-devel-request at lists.geeklog.net geeklog-devel-request at lists.geeklog.net
Tue Dec 28 13:00:02 EST 2004

Send geeklog-devel mailing list submissions to
geeklog-devel at lists.geeklog.net

To subscribe or unsubscribe via the World Wide Web, visit
http://lists.geeklog.net/listinfo/geeklog-devel
or, via email, send a message with subject or body 'help' to
geeklog-devel-request at lists.geeklog.net

You can reach the person managing the list at
geeklog-devel-admin at lists.geeklog.net

When replying, please edit your Subject line so it is more specific
than "Re: Contents of geeklog-devel digest..."


Today's Topics:

1. [Fwd: Re: [W3B7V2D] Server activity] (Tony Bibbs)
2. [Fwd: Re: [propel] Performance Benchmarks] (Tony Bibbs)
3. Re: [Fwd: Re: [W3B7V2D] Server activity] (Vincent Furia)
4. Re: [Fwd: Re: [W3B7V2D] Server activity] (Tony Bibbs)
5. [Fwd: Re: [W3B7V2D] Server activity] (Tony Bibbs)
6. Re: Geeklog-2 CVS, To-do list (Vincent Furia)

--__--__--

Message: 1
Date: Mon, 27 Dec 2004 17:14:21 -0600
From: Tony Bibbs <tony at tonybibbs.com>
To: geeklog-devel at lists.geeklog.net
Subject: [geeklog-devel] [Fwd: Re: [W3B7V2D] Server activity]
Reply-To: geeklog-devel at lists.geeklog.net

How's that for customer service?

--Tony

-------- Original Message --------
Subject: Re: [W3B7V2D] Server activity
Date: Sat, 25 Dec 2004 15:51:14 EST
From: QuickServe Support <qs at pair.com>
To: tony at tonybibbs.com



Hello,

Due to the activity on your server, I added an extra 512MB to your RAM
total. The server was dipping into swap space quite a bit.

Down time was less than 3 minutes.

Thanks,

Amon
qs at pair.com


--__--__--

Message: 2
Date: Mon, 27 Dec 2004 17:27:16 -0600
From: Tony Bibbs <tony at tonybibbs.com>
To: geeklog-devel at lists.geeklog.net
Subject: [geeklog-devel] [Fwd: Re: [propel] Performance Benchmarks]
Reply-To: geeklog-devel at lists.geeklog.net

Here you go.

Results aren't the greatest. I've offered to do a detailed execution
profile for the Creole developers so they might have an idea where to
start looking should they decide to trim sometime off.

I think ideally we'd at least get PEAR::DB-ish performance.

--Tony


-------- Original Message --------
Subject: Re: [propel] Performance Benchmarks
Date: Sun, 26 Dec 2004 21:32:20 +0100
From: Dénes Szabó <d.taylor42 at gmail.com>
Reply-To: users at propel.tigris.org
To: users at propel.tigris.org
References: <41BEFBAA.3080602 at tonybibbs.com>
<41C10D74.2020502 at velum.net> <41C112F0.4050706 at tonybibbs.com>
<1c4a145c04121601161bcee6e0 at mail.gmail.com>
<41C7323C.1000802 at tonybibbs.com>



Hi!

I forgot it. Sorry!

I used the adodb's benchmark suite. (http://adodb.sourceforge.net/ ->
http://phplens.com/lens/adodb/)

I wrote a test case for creole:

benchcreole.php

<?php

include("_creole.inc.php");
include("_benchmark.inc.php");

?>

_creole.inc.php:

<?php

// average 2.65,2.65, 2.64, 2.66 for 100 times

ini_set('include_path', '.:pear');
include "creole/Creole.php";

$DBNAME = 'CREOLE DB';

function &Connect()
{
$dsn = "mysql://donci:asd123@localhost/test";
$db = Creole::GetConnection($dsn);
return $db;
}

// fetchInto -- note that it is less intuitive as DB_OK must be
explicitly checked
function QueryOnce(&$db,$debug)
{
$rs = $db->executeQuery('select
productid,productname,unitsinstock,unitprice from products');
while ($rs->next()) {
$id=$rs->getInt('productid');
$name=$rs->getString('productname');
$unitsinstock=$rs->getInt('unitsinstock');
$unitprice=$rs->getFloat('unitprice');

if ($debug) {
print "$id, $name, $unitsinstock, $unitprice<br>";
}
}

$rs->close();
}

// fetchRow is slower but superior API
function QueryOnce2(&$db,$debug)
{
$rs = $db->query('select productid,productname,unitsinstock,unitprice
from products');
while ($fields = $rs->fetchRow()) {
$id=$fields[0];
$name=$fields[1];
$unitsinstock=$fields[2];
$unitprice=$fields[3];

if ($debug) {
print "$id, $name, $unitsinstock, $unitprice<br>";
}
}

$rs->free();
}
?>

My dir structure is:

|-- adodb/

|-- pear

| |-- DB

| |-- creole

| `-- jargon

|-- _adodb.inc.php

|-- _benchmark.inc.php

|-- _creole.inc.php

|-- _dbx.inc.php

|-- _mdb.inc.php

|-- _metabase.inc.php

|-- _mysql.inc.php

|-- _pear.inc.php

|-- _phplib.inc.php

|-- benchadodb.php

|-- benchcreole.php

|-- benchdbx.php

|-- benchmdb.php

|-- benchmetabase.php

|-- benchmysql.php

|-- benchpear.php

|-- benchphplib.php

|-- createproducts.sql

`-- readme.txt

I used mysql for test (createproducts.sql)

My results are (with 2000 iteration!):

CREOLE DB: Queried 2000 times for 12.62241601944 seconds
PEAR DB: Queried 2000 times for 8.1311810016632 seconds
ADODB: Queried 2000 times for 4.7065849304199 seconds
MySQL: Queried 2000 times for 2.3287560939789 seconds

The smallest is the best. It is sad but the creole is the slowest. But
creole makes some plus goodies (getInt( ), getString( )). The adodb is
a very good db layer. (I used to it a lot).


On Mon, 20 Dec 2004 14:12:44 -0600, Tony Bibbs <tony at tonybibbs.com> wrote:

> Dénes, I never got this. Can you please post your results?

>

> --Tony




--
[dt]

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe at propel.tigris.org
For additional commands, e-mail: users-help at propel.tigris.org


--__--__--

Message: 3
Date: Mon, 27 Dec 2004 18:31:15 -0500
From: Vincent Furia <vfuria at gmail.com>
To: geeklog-devel at lists.geeklog.net, Tony Bibbs <tony at tonybibbs.com>
Subject: Re: [geeklog-devel] [Fwd: Re: [W3B7V2D] Server activity]
Reply-To: geeklog-devel at lists.geeklog.net

Hey Tony,

Still getting an SQL error from www.geeklog.net.

-Vinny


On Mon, 27 Dec 2004 17:14:21 -0600, Tony Bibbs <tony at tonybibbs.com> wrote:

> How's that for customer service?

>

> --Tony

>

> -------- Original Message --------

> Subject: Re: [W3B7V2D] Server activity

> Date: Sat, 25 Dec 2004 15:51:14 EST

> From: QuickServe Support <qs at pair.com>

> To: tony at tonybibbs.com

>

> Hello,

>

> Due to the activity on your server, I added an extra 512MB to your RAM

> total. The server was dipping into swap space quite a bit.

>

> Down time was less than 3 minutes.

>

> Thanks,

>

> Amon

> qs at pair.com

>

> _______________________________________________

> geeklog-devel mailing list

> geeklog-devel at lists.geeklog.net

> http://lists.geeklog.net/listinfo/geeklog-devel

>


--__--__--

Message: 4
Date: Mon, 27 Dec 2004 17:37:18 -0600
From: Tony Bibbs <tony at tonybibbs.com>
To: geeklog-devel at lists.geeklog.net
Subject: Re: [geeklog-devel] [Fwd: Re: [W3B7V2D] Server activity]
Reply-To: geeklog-devel at lists.geeklog.net

Yeah, I sent a note in.

--Tony

Vincent Furia wrote:


>Hey Tony,

>

>Still getting an SQL error from www.geeklog.net.

>

>-Vinny

>

>

>On Mon, 27 Dec 2004 17:14:21 -0600, Tony Bibbs <tony at tonybibbs.com> wrote:

>

>

>>How's that for customer service?

>>

>>--Tony

>>

>>-------- Original Message --------

>>Subject: Re: [W3B7V2D] Server activity

>>Date: Sat, 25 Dec 2004 15:51:14 EST

>>From: QuickServe Support <qs at pair.com>

>>To: tony at tonybibbs.com

>>

>>Hello,

>>

>>Due to the activity on your server, I added an extra 512MB to your RAM

>>total. The server was dipping into swap space quite a bit.

>>

>>Down time was less than 3 minutes.

>>

>>Thanks,

>>

>>Amon

>>qs at pair.com

>>

>>_______________________________________________

>>geeklog-devel mailing list

>>geeklog-devel at lists.geeklog.net

>>http://lists.geeklog.net/listinfo/geeklog-devel

>>

>>

>>

>_______________________________________________

>geeklog-devel mailing list

>geeklog-devel at lists.geeklog.net

>http://lists.geeklog.net/listinfo/geeklog-devel

>

>



--__--__--

Message: 5
Date: Tue, 28 Dec 2004 08:51:54 -0600
From: Tony Bibbs <tony at tonybibbs.com>
To: geeklog-devel at lists.geeklog.net
Subject: [geeklog-devel] [Fwd: Re: [W3B7V2D] Server activity]
Reply-To: geeklog-devel at lists.geeklog.net



-------- Original Message --------
Subject: Re: [W3B7V2D] Server activity
Date: Tue, 28 Dec 2004 02:02:43 EST
From: QuickServe Support <qs at pair.com>
To: Tony Bibbs <tony at tonybibbs.com>



Hello,

I traced the problem down to the "sessions" table in your
geeklog_production database being marked as crashed. I was able to
repair this table, and the site now appears to be working correctly
again. Please let me know if you are still having any problems with
it, I'll continue to check into it as well. Sorry for the problems.

-Kevin O.

pair Networks
qs at pair.com


>

> Thanks, however, ever since this upgrade, our site

> http://www.geeklog.net has been down getting a SQL error). We've made

> no modifications to any of the code running up there in over a week.

>

> Ideas?

>

> --Tony

>

> QuickServe Support wrote:

>

> >Hello,

> >

> >Due to the activity on your server, I added an extra 512MB to your RAM

> >total. The server was dipping into swap space quite a bit.

> >

> >Down time was less than 3 minutes.

> >

> >Thanks,

> >

> >Amon

> >qs at pair.com

> >

> >



--__--__--

Message: 6
Date: Tue, 28 Dec 2004 12:14:23 -0500
From: Vincent Furia <vfuria at gmail.com>
To: geeklog-devel at lists.geeklog.net
Subject: Re: [geeklog-devel] Geeklog-2 CVS, To-do list
Reply-To: geeklog-devel at lists.geeklog.net

Question on 7: Should Geeklog_ActionManager.php actually be a child of
the BaseActionlistenerPeer.php propel class?

-Vinny


On Mon, 20 Dec 2004 16:51:23 -0600, Tony Bibbs <tony at tonybibbs.com> wrote:

> Here's an update on this list:

>

> Tony Bibbs wrote:

>

> > Here's the to-do list, short term:

> >

> > 1) BaseViewFlexy needs the translation stuff ironed out

>

> Sorta done. Needs to be thought through completely as I'm sure I

> haven't covered all our cases (not to mention I'm still fuzzy on how

> Translation2 works). Also need to consider the possiblity of using the

> xml translation2 support given all the dependencies for the gettext

> implementation.

>

> > 2) Data model needs Dwights attention regarding the count fields (i.e.

> > gl2_user.num_views) so we can make a final decision and get those

> > changes in the data model.

>

> Dwight?

>

> > 3) Geeklog_LoginCommand.php needs to be implemented. This should log

> > a user in, get the user object from the database (including

> > privileges) and serialize it to the session.

>

> Rought draft is done.

>

> > 4) BaseViewFlexyUser.php needs to be updated to correctly deserialize

> > the user object from the session. If the user object doesn't exist it

> > should forward on to the Login page. Otherwise it should forward on

> > to...well that's the million dollar question. Given we have the

> > concept of plugins for everything, we probably need to allow the user

> > to specify the default one to use for the homepage, no?

>

> Rough draft done. I'll build a kernel home page that will be the

> default in the case that no plugins are installed.

>

> > 5) We need the filtering class defined. I know Blaine volunteered

> > originally...can you still do it?

>

> Blaine was going to look into this since this would also benefit 1.3.x

>

> > 6) Plugin API needs to have dependency checking added to it

>

> Done

>

> > 7) Event Manager needs to be implemented.

>

> This will be my next project, I guess.

>

> --Tony

> _______________________________________________

> geeklog-devel mailing list

> geeklog-devel at lists.geeklog.net

> http://lists.geeklog.net/listinfo/geeklog-devel

>



--__--__--

_______________________________________________
geeklog-devel mailing list
geeklog-devel at lists.geeklog.net
http://lists.geeklog.net/listinfo/geeklog-devel


End of geeklog-devel Digest

More information about the geeklog-devtalk mailing list