Re: [PHP] HELP! IBase - PHP

[Brett Bandy]

What do you mean flatlines?  Does the solaris machine's CPU move to ~100%
utilization?

You might be hitting the automatic garbage collection.  Use gstat -h to
watch your transactions states.  Particularly the oldest transaction and the
oldest interesting transaction.  By default an auto garbage collection kicks
off when the difference between these two numbers is 2.

If this is happening it might indicate that you aren't using your
transactions as effective as possible.  For example leaving them open for
extended periods of time.

hope this helps,
Brett Bandy

""Niel Zeeman"" <[EMAIL PROTECTED]> wrote in message
001c01c09bf9$4cd89c00$756410ac@NielZ">news:001c01c09bf9$4cd89c00$756410ac@NielZ...
Hi there

I have a big problem and would greatly appreciate help..

I have a production site runnig the php4.0.4 isapi on IIS5 with a ibase
backend db running on solaris

Now I have the problem that when ever a couple of people( 2-6) login from
the web the database flatlines...
This is with about 10-30 local users logged into the db aswell.

the site is basically a data capturing site

please any help is welcome

 thanks

Niel Zeeman
Tel(W): (043)7014247
Cell: 082 651 4083
eMail: [EMAIL PROTECTED]




-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP] Interbase

[Brett Bandy]

you might try www.ibphoenix.com as they have more info (than the Borland
site) regarding InterBase.

Brett

""Chris"" <[EMAIL PROTECTED]> wrote in message
03fd01c0a73c$15183c00$01c8c8c8@ibcserver">news:03fd01c0a73c$15183c00$01c8c8c8@ibcserver...
Hi,
Has anyone here dealt with the new Interbase 6.0 License?
The web site says it is a free download for development, but I can't find
any info about commercial use, and their sales office doesn't seem to know
either, and they haven't called back yet.

Anyone know what the commercial license is? Is it still free?

Thanks,
Chris




-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP] Error with ldap

[Brett Bandy]

php_ldap.dll also requires libsasl.dll, so make sure you move this dll to
\winnt\system32 as well.

Brett

"Alain ROMERO" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I copy 'msvcrtd.dll' in winnt\system32 and php3 works fine, but not php4

HELP !

Alain ROMERO a écrit :

> PHP 4.0.2 on Win32
> or PHP 3 on Win32
> extension=php_ldap.dll   is on in the php.ini file
>
> I get 'Unable to load php_ldap.dll' (PHP4) when I call a php file ?
> I get 'Call to an unsupported function ldap_connect()' (PHP3)  ?
>
> Help please ?
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP] Opening/closing a DB

[Brett Bandy]

With InterBase using persistent connections will save a lot of time.
However,
you need to be extra careful with how you manage transactions.  InterBase
uses
a versioning engine for transaction management and you can easily screw up
the
system performance if you don't manage your transactions correctly.

Make sure you use short quick transactions.  Don't leave a transaction open,
always make
sure the transaction is committed or rolledback.  Lingering transactions are
probably the
biggest performance problem you'll encounter with InterBase.

Brett

""Daniel Grace"" <[EMAIL PROTECTED]> wrote in message
004101c0a992$80fa98c0$b4bc9a40@hades">news:004101c0a992$80fa98c0$b4bc9a40@hades...
> On Saturday, March 10, 2001 at 7:03 AM, Todd Cary
<[EMAIL PROTECTED]>
> wrote:
>
> > I have some questions about PHP and it's interaction with a DB (namely,
> > Interbase).  My client's application uses a DB extensively and I am not
> > clear about opening and closing a DB -  the price one pays.
> >
> > First, I notice that the approximate time to open a connection to my DB
> > on my test system is 1 second with a "locate time" of another second.
> > So, 50% of the time is opening the DB.
> -- snip --
>
> I haven't used Interbase, but if it's like most of PHP's database
> interfaces, it isn't too critical to worry about closing the database
> connection. PHP will do so automatically when your script ends.
>
> -- unsnip --
> >
> > The next question envolves closing the DB and returning memory.
> >
> > ibase_free_result;
> > ibase_close($dbh);
> >
> > What will happen if in my code I forget to do this in a place or two?
> > Will the system eventually crash?
> -- snip --
>
> The Interbase extensions to PHP support persistent connections:
> http://www.php.net/manual/en/function.ibase-pconnect.php (see
> mysql_pconnect() as well for more general info on persistent connections).
> With persistent connections, the overhead in connecting to the database
> backend is minimized since the same connection can be shared across
multiple
> pages. This won't work with the CGI version of PHP however.
>
>  - Daniel Grace 
>
>   "Space may be the final frontier but its made in a Hollywood basement."
> - Red Hot Chili Peppers - Californication
>
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP] LDAP problem

[Brett Bandy]

Make sure all the dlls used by php3_ldap.dll are available.

I have php4 and the php_ldap.dll requires the libsasl.dll to be available.

Brett

""almir"" <[EMAIL PROTECTED]> wrote in message
99d00g$j4h$[EMAIL PROTECTED]">news:99d00g$j4h$[EMAIL PROTECTED]...
> ok
> i am usng php3.0.11 ,IIS4 and NT4 trying to connect to ldap server but i
get
> a error
> Fatal error: Call to unsupported or undefined function ldap_connect() in
...
> i have included php3_ldap.dll in my php3.ini, i have even tried to include
> it dinamicaly with dl but then i get
>
> Fatal error: Unable to load dynamic library './php3_ldap.dll'
>




-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP] sql problem

[Brett Bandy]

InterBase isn't real good with subselects.

Try using a join instead:

select e.empname from employer e join badclient b on e.empno =
b.employercode where b.pesal = '$Persal';

Brett

""Wade Halsey"" <[EMAIL PROTECTED]> wrote in message
00a501c0b38b$e2a27ea0$256410ac@wadeh">news:00a501c0b38b$e2a27ea0$256410ac@wadeh...
Hi ppl

("select empname from employer where empno = (select employercode from
badclient where pesal = '$Persal')")

Could anyone help me out with the syntax?

Im running an interbase db and php4.04

Thanks
Wade




-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]