On Tue, Feb 13, 2007, Jim Steil wrote:
>
> Hi:
>
> Is there an easy way to return a row with a maximum column value in
> it? For example:
>
> I have a log records table. This table logs the status of a bunch of
> processes that I schedule here. For a given process, I want to get
> th
Oleg Broytmann wrote:
> On Mon, Feb 12, 2007 at 08:52:27PM -0500, Robert Hicks wrote:
>> Oracle?
>
>Not in 0.8. Are you a developer or a user of OrcaleConnection? I'd like
> to hear some reports about its state.
>
> PS. Please do not overquote.
>
> Oleg.
I have 9i at work and I would like t
Hi:
Is there an easy way to return a row with a maximum column value in it?
For example:
I have a log records table. This table logs the status of a bunch of
processes that I schedule here. For a given process, I want to get the
latest log record along with the name of the process.
The m
On Tue, Feb 13, 2007 at 09:05:04PM +, Luke Opperman wrote:
> but trac is now down
I'll try to contact its admin...
> Any opposition to adding a __sqlrepr__/tablesUsedImmediate to
> Alias/AliasTable,
> and having SQLJoin just sqlrepr it's components as otherwise expected?
IWB interesti
Ok, two things today:
1. Preview implementation of just the "use sqlbuilder.Select for queryForSelect"
part is in trac #291, but trac is now down. I've attached the patch (against svn
r2158) to this message too.
2. Found a fun problem with sqlbuilder.SQLJoin. Since Alias's don't have a
__sqlrepr_
On Tue, Feb 13, 2007 at 06:07:00PM +0100, Lutz Steinborn wrote:
> have a nice day and thank you for the great work on sqlobject !
Thank you!
Oleg.
--
Oleg Broytmannhttp://phd.pp.ru/[EMAIL PROTECTED]
Programmers don't die, they just GOSUB without RETURN.
On Tue, 13 Feb 2007 19:33:39 +0300
Oleg Broytmann <[EMAIL PROTECTED]> wrote:
> On Tue, Feb 13, 2007 at 05:15:30PM +0100, Lutz Steinborn wrote:
> > every time then we are getting an object from the database
> > (postgres) with myClass.select(myQuery) two queries are in the
> > DB log. The first on
On Tue, Feb 13, 2007 at 05:15:30PM +0100, Lutz Steinborn wrote:
> every time then we are getting an object from the database
> (postgres) with myClass.select(myQuery) two queries are in the
> DB log. The first on did an "select count(*)" and the second
> gets the data with limit.
Really? It is
Hi,
every time then we are getting an object from the database
(postgres) with myClass.select(myQuery) two queries are in the
DB log. The first on did an "select count(*)" and the second
gets the data with limit.
This is a real performance killer. Why is it so and is where a
way to stop this ?
A
On 2/13/07, Tor Hildrum <[EMAIL PROTECTED]> wrote:
> Ok, I made all the changes suggested but it still wasn't as fast as I
> expected it to be.
>
> I tried changing from SQLite to MySQL and the whole function is down
> to a few microseconds. So, I'm guessing part of the problem was due to
> SQLite.
On Tue, Feb 13, 2007 at 10:00:57AM -0500, Sells, Fred wrote:
> When I go to sqlobject.org, I don't see a download link for 0.8.0
http://sqlobject.org/download.html :
"The latest releases are always available on the Python Cheese Shop."
http://cheeseshop.python.org/pypi/SQLObject
(But yes,
When I go to sqlobject.org, I don't see a download link for 0.8.0
also could you indicate which versions of python are required with different
sqlobjects, my organization does not generally use the latest & greatest
(currently using 2.3)
--
Ok, I made all the changes suggested but it still wasn't as fast as I
expected it to be.
I tried changing from SQLite to MySQL and the whole function is down
to a few microseconds. So, I'm guessing part of the problem was due to
SQLite. Probably should
have checked that first.
I'm sticking with t
On Tue, Feb 13, 2007 at 01:44:37PM +0100, Tor Hildrum wrote:
> class Loan(SQLObject):
> class sqlmeta:
> cacheValues = False
Are you sure you really want to issue a separate SELECT for an every
attribute access? This is really slow!
Oleg.
--
Oleg Broytmannhttp://phd.p
"Tor Hildrum" <[EMAIL PROTECTED]> writes:
> Here is the code:
>
> def editItem(self, name=None, comment=None):
>
> ## Fetch the item
> try:
> item = Item.byName(name)
> except SQLObjectNotFound:
> turbogears.flash("Err
I'm having extreme performance issues, due to some lousy
code. I'm hoping this is my codes fault or SQLite, and not the fault
of SQLObject or cherryPy.
This is a turbogears-project btw.
Here is the code:
def editItem(self, name=None, comment=None):
On Mon, Feb 12, 2007 at 08:52:27PM -0500, Robert Hicks wrote:
> Oracle?
Not in 0.8. Are you a developer or a user of OrcaleConnection? I'd like
to hear some reports about its state.
PS. Please do not overquote.
Oleg.
--
Oleg Broytmannhttp://phd.pp.ru/[EMAIL PROTE
On Tue, Feb 13, 2007 at 01:31:28AM +0100, sophana wrote:
> I can still see that sqlobject is fetching all data when doing a
> iterating a select.
> But not when accessing a multipleJoin. For the multiple join access to
> refetch the data I have to make a connection.cache.clear(), with or
> without
18 matches
Mail list logo
