Re: [phplib-dev] DB_Sql: queries with priorities From: Eric Ries (eries <email protected>)
Date: 09/03/00

How about adding a per-instance variable to DB_Sql objects which controls
the priority? That way, you could have different objects for different
priorities.

Modifying queries is a bit tricky, which is why I urge everyone to check
out the SQL Abstraction Layer at http://enzyme.sourceforge.net - it's a
handy OO library for creating, combining, and modifying SQL statements.
It's GPL'ed too.

Eric

At 02:05 PM 9/3/00, Sebastian Bergmann wrote:
> Hi,
>
> I have a proposal to improve DB_Sql->query() a little.
>
> MySQL offers three keywords ( "DELAYED", "LOW_PRIORITY" and
>"HIGH_PRIORITY" ) to access its scheduler.
>
> I think other systems feature similar statements, so why not implement
>query() as follows
>
> function query( $Query_String, $Priority )
>
> ?
>
> for system that support it query() could now transparently modify
>$Query_String accordingly and perform the query.
>
> Just a thought,
>Sebastian
>
>--
> <?php $a=explode(" " ,"119 130 128 129 45 110 123 124 129 117 114 127 45 ".
> "125 117 125 45 117 110 112 120 114 127");for($i=0;$i<sizeof($a);$i++)print
> chr($a[$i]-13); /* http://sb.phpOpenTracker.de | sb <email protected> */ ?>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: phplib-dev-unsubscribe <email protected>
>For additional commands, e-mail: phplib-dev-help <email protected>

---------------------------------------------------------------------
To unsubscribe, e-mail: phplib-dev-unsubscribe <email protected>
For additional commands, e-mail: phplib-dev-help <email protected>