[Fwd: [ secureideas-Feature Requests-2129530 ] Script checks DB for columns multiple times]

View: New views
9 Messages — Rating Filter:   Alert me  

[Fwd: [ secureideas-Feature Requests-2129530 ] Script checks DB for columns multiple times]

by Micah Gersten :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

I meant for this to be a bug.  Can someone move it or should I create
another instance?

Thank you,
Micah Gersten
onShore Networks
Internal Developer
http://www.onshore.com



-------- Original Message --------
Subject: [ secureideas-Feature Requests-2129530 ] Script checks DB for
columns multiple times
Date: Fri, 26 Sep 2008 01:33:54 +0000
From: SourceForge.net <noreply@...>
To: noreply@...



Feature Requests item #2129530, was opened at 2008-09-25 20:33
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=635585&aid=2129530&group_id=103348

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Database
Group: BASE 1.x
Status: Open
Priority: 5
Private: No
Submitted By: Micah Gersten (micah26)
Assigned to: Nobody/Anonymous (nobody)
Summary: Script checks DB for columns multiple times

Initial Comment:
During execution, especially archiving, the script uses an ADODB function to check if a column exists every time the function is called as opposed to caching it after the first time the function is run during the script execution.

----------------------------------------------------------------------

You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=635585&aid=2129530&group_id=103348


-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Secureideas-base-devel mailing list
Secureideas-base-devel@...
https://lists.sourceforge.net/lists/listinfo/secureideas-base-devel

Re: [Fwd: [ secureideas-Feature Requests-2129530 ] Script checks DB for columns multiple times]

by Kevin Johnson :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

I would not agree that its a bug, but you are able to set it to what  
ever you would like in the feature request... Please do not create  
another one, use the existing one.

Kevin

On Sep 25, 2008, at 9:36 PM, Micah Gersten wrote:

> I meant for this to be a bug.  Can someone move it or should I create
> another instance?
>
> Thank you,
> Micah Gersten
> onShore Networks
> Internal Developer
> http://www.onshore.com
>
>
>
> -------- Original Message --------
> Subject: [ secureideas-Feature Requests-2129530 ] Script checks DB  
> for
> columns multiple times
> Date: Fri, 26 Sep 2008 01:33:54 +0000
> From: SourceForge.net <noreply@...>
> To: noreply@...
>
>
>
> Feature Requests item #2129530, was opened at 2008-09-25 20:33
> Message generated for change (Tracker Item Submitted) made by Item  
> Submitter
> You can respond by visiting:
> https://sourceforge.net/tracker/?func=detail&atid=635585&aid=2129530&group_id=103348
>
> Please note that this message will contain a full copy of the  
> comment thread,
> including the initial issue submission, for this request,
> not just the latest update.
> Category: Database
> Group: BASE 1.x
> Status: Open
> Priority: 5
> Private: No
> Submitted By: Micah Gersten (micah26)
> Assigned to: Nobody/Anonymous (nobody)
> Summary: Script checks DB for columns multiple times
>
> Initial Comment:
> During execution, especially archiving, the script uses an ADODB  
> function to check if a column exists every time the function is  
> called as opposed to caching it after the first time the function is  
> run during the script execution.
>
> ----------------------------------------------------------------------
>
> You can respond by visiting:
> https://sourceforge.net/tracker/?func=detail&atid=635585&aid=2129530&group_id=103348
>
>
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's  
> challenge
> Build the coolest Linux based applications with Moblin SDK & win  
> great prizes
> Grand prize is a trip for two to an Open Source event anywhere in  
> the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> Secureideas-base-devel mailing list
> Secureideas-base-devel@...
> https://lists.sourceforge.net/lists/listinfo/secureideas-base-devel
>


-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Secureideas-base-devel mailing list
Secureideas-base-devel@...
https://lists.sourceforge.net/lists/listinfo/secureideas-base-devel

Re: [Fwd: [ secureideas-Feature Requests-2129530 ] Script checks DB for columns multiple times]

by Micah Gersten :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

I'll leave it as a feature request.  If I make a patch, can it go into
the next release?

Thank you,
Micah Gersten
onShore Networks
Internal Developer
http://www.onshore.com



Kevin Johnson wrote:

> I would not agree that its a bug, but you are able to set it to what
> ever you would like in the feature request... Please do not create
> another one, use the existing one.
>
> Kevin
>
> On Sep 25, 2008, at 9:36 PM, Micah Gersten wrote:
>
>> I meant for this to be a bug.  Can someone move it or should I create
>> another instance?
>>
>> Thank you,
>> Micah Gersten
>> onShore Networks
>> Internal Developer
>> http://www.onshore.com
>>
>>
>>
>> -------- Original Message --------
>> Subject:     [ secureideas-Feature Requests-2129530 ] Script checks
>> DB for
>> columns multiple times
>> Date:     Fri, 26 Sep 2008 01:33:54 +0000
>> From:     SourceForge.net <noreply@...>
>> To:     noreply@...
>>
>>
>>
>> Feature Requests item #2129530, was opened at 2008-09-25 20:33
>> Message generated for change (Tracker Item Submitted) made by Item
>> Submitter
>> You can respond by visiting:
>> https://sourceforge.net/tracker/?func=detail&atid=635585&aid=2129530&group_id=103348
>>
>>
>> Please note that this message will contain a full copy of the comment
>> thread,
>> including the initial issue submission, for this request,
>> not just the latest update.
>> Category: Database
>> Group: BASE 1.x
>> Status: Open
>> Priority: 5
>> Private: No
>> Submitted By: Micah Gersten (micah26)
>> Assigned to: Nobody/Anonymous (nobody)
>> Summary: Script checks DB for columns multiple times
>>
>> Initial Comment:
>> During execution, especially archiving, the script uses an ADODB
>> function to check if a column exists every time the function is
>> called as opposed to caching it after the first time the function is
>> run during the script execution.
>>
>> ----------------------------------------------------------------------
>>
>> You can respond by visiting:
>> https://sourceforge.net/tracker/?func=detail&atid=635585&aid=2129530&group_id=103348
>>
>>
>>
>> -------------------------------------------------------------------------
>>
>> This SF.Net email is sponsored by the Moblin Your Move Developer's
>> challenge
>> Build the coolest Linux based applications with Moblin SDK & win
>> great prizes
>> Grand prize is a trip for two to an Open Source event anywhere in the
>> world
>> http://moblin-contest.org/redirect.php?banner_id=100&url=/
>> _______________________________________________
>> Secureideas-base-devel mailing list
>> Secureideas-base-devel@...
>> https://lists.sourceforge.net/lists/listinfo/secureideas-base-devel
>>

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Secureideas-base-devel mailing list
Secureideas-base-devel@...
https://lists.sourceforge.net/lists/listinfo/secureideas-base-devel

Re: [Fwd: [ secureideas-Feature Requests-2129530 ] Script checks DB for columns multiple times]

by Kevin Johnson-7 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Micah Gersten wrote:
> I'll leave it as a feature request.  If I make a patch, can it go into
> the next release?

As long as it works. :)

Kevin
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFI3FHFGDcWptZ2zmQRAni+AKCoO0RIuILav47ww8slhT9PAmEMUACgnoc6
z4cCXPy65u+ZsL+8xYuBYQA=
=2GL1
-----END PGP SIGNATURE-----

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Secureideas-base-devel mailing list
Secureideas-base-devel@...
https://lists.sourceforge.net/lists/listinfo/secureideas-base-devel

Re: [Fwd: [ secureideas-Feature Requests-2129530 ] Script checks DB for columns multiple times]

by Micah Gersten :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Ok.  I uploaded the patch.  It's attached to the bug.  The only problem
if someone has a setup where they cache static variables between page loads.

Thank you,
Micah Gersten
onShore Networks
Internal Developer
http://www.onshore.com



Kevin Johnson wrote:
> Micah Gersten wrote:
> > I'll leave it as a feature request.  If I make a patch, can it go into
> > the next release?
>
> As long as it works. :)
>
> Kevin


-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Secureideas-base-devel mailing list
Secureideas-base-devel@...
https://lists.sourceforge.net/lists/listinfo/secureideas-base-devel

Re: [Fwd: [ secureideas-Feature Requests-2129530 ] Script checks DB for columns multiple times]

by Kevin Johnson-7 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Micah Gersten wrote:
> Ok.  I uploaded the patch.  It's attached to the bug.  The only problem
> if someone has a setup where they cache static variables between page loads.

Am I correct in thinking that this would not be common?

Kevin
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFI3FlFGDcWptZ2zmQRApnJAJ98mGYjxcMtNsG23dwukAJthVuzZwCgzdse
UU5w4TbLokO22Fh5LTEVlgU=
=syeC
-----END PGP SIGNATURE-----

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Secureideas-base-devel mailing list
Secureideas-base-devel@...
https://lists.sourceforge.net/lists/listinfo/secureideas-base-devel

Re: [Fwd: [ secureideas-Feature Requests-2129530 ] Script checks DB for columns multiple times]

by Micah Gersten :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

I don't believe it is.  It's generally used for massive apps with speed
problems.

Thank you,
Micah Gersten
onShore Networks
Internal Developer
http://www.onshore.com



Kevin Johnson wrote:
> Micah Gersten wrote:
> > Ok.  I uploaded the patch.  It's attached to the bug.  The only problem
> > if someone has a setup where they cache static variables between
> page loads.
>
> Am I correct in thinking that this would not be common?
>
> Kevin


-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Secureideas-base-devel mailing list
Secureideas-base-devel@...
https://lists.sourceforge.net/lists/listinfo/secureideas-base-devel

Re: [Fwd: [ secureideas-Feature Requests-2129530 ] Script checks DB for columns multiple times]

by Micah Gersten :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Also, you generally have to add the variables to the cache:
http://us3.php.net/apc

Thank you,
Micah Gersten
onShore Networks
Internal Developer
http://www.onshore.com



Micah Gersten wrote:

> I don't believe it is.  It's generally used for massive apps with speed
> problems.
>
> Thank you,
> Micah Gersten
> onShore Networks
> Internal Developer
> http://www.onshore.com
>
>
>
> Kevin Johnson wrote:
>  
>> Micah Gersten wrote:
>>    
>>> Ok.  I uploaded the patch.  It's attached to the bug.  The only problem
>>> if someone has a setup where they cache static variables between
>>>      
>> page loads.
>>
>> Am I correct in thinking that this would not be common?
>>
>> Kevin
>>    
>
>
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> Secureideas-base-devel mailing list
> Secureideas-base-devel@...
> https://lists.sourceforge.net/lists/listinfo/secureideas-base-devel
>  

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Secureideas-base-devel mailing list
Secureideas-base-devel@...
https://lists.sourceforge.net/lists/listinfo/secureideas-base-devel

Re: [Fwd: [ secureideas-Feature Requests-2129530 ] Script checks DB for columns multiple times]

by Micah Gersten :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Is it possible to get the patch for this in CVS?

Thank you,
Micah Gersten
onShore Networks
Internal Developer
http://www.onshore.com



Kevin Johnson wrote:
> Micah Gersten wrote:
> > I'll leave it as a feature request.  If I make a patch, can it go into
> > the next release?
>
> As long as it works. :)
>
> Kevin


-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Secureideas-base-devel mailing list
Secureideas-base-devel@...
https://lists.sourceforge.net/lists/listinfo/secureideas-base-devel
LightInTheBox - Buy quality products at wholesale price!