php-windows Digest 16 Apr 2001 15:56:15 -0000 Issue 547
Topics (messages 6766 through 6775):
Re: MySql pconnect
6766 by: Plutarck
6772 by: Svensson, B.A.T.
6773 by: Svensson, B.A.T.
Upload file
6767 by: Cenker Sisman
6768 by: Piotr Pluciennik
Error: "Couldn't spawn child process"
6769 by: Anders Landberg
Storing images as references in a database
6770 by: lars Eirik Rønning
Writing to Mapped Drive : Permission Denied
6771 by: Paul Wieland
mysql from Java Applets
6774 by: Barry
In case of smtp failure :: Alternate SMTP server use :: how?
6775 by: Dickerson, Monty
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[EMAIL PROTECTED]
----------------------------------------------------------------------
As expressed in the article, the question is what the database was designed
to actually "do".
MySQL creates quick connections, responds to SELECT statements as fast as
anything can, has a small footprint, and does not require any special fees
to use it. And yes, it's open source. For the vast majority of web sites,
MySQL is an absolutely perfect fit.
But if you are a bank or running a real-time game that requires player data
to be saved constantly, for instance, something like Oracle is what you'll
need (for now).
But most people just don't _need_ transactions. However, MySQL is planning
to add support for such things in later versions. You have to keep in mind
that MySQL is new compared to Oracle. It makes sense that it has a smaller
amount of features.
And on an unrelated issue, down with bloatware :)
--
Plutarck
Should be working on something...
...but forgot what it was.
""Svensson, B.A.T. "" <[EMAIL PROTECTED]> wrote in message
27E647E5629ED211BF78009027289C630288B349@mail1">news:27E647E5629ED211BF78009027289C630288B349@mail1...
> >-----Original Message-----
> >From: Plutarck []
>
> >http://www.webtechniques.com/archives/2001/01/jagielski/
> >
> >Skip down to where it mentions databases...very enlightening.
>
> Yeah... MySQL is even a worse RDBM's than I thought since before.
> No stored procedure, no transactions, no .... jezus!!!
>
>
>
> --
> PHP Windows 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]
>
>-----Original Message-----
>From: Joe Brown [mailto:[EMAIL PROTECTED]]
>Sent: Sunday, April 15, 2001 8:53 PM
>But my point is that the communication overhead is still gained by process
>based systems. True they don't have the same pooling ability, as does a
>threaded process management. Overhead saved using pconnect is that which
is
>being debated here.
How much overhead (in milli/micro seconds) are we talking about then?
A typical server would be a 600-800 MHz multi-CPU machine with about
1-4 GB RAM.
I suspect that this discussion is just academically since the overhead
time in most cases probably are sufficient low enough to just ignore - or?
>-----Original Message-----
>From: Plutarck [mailto:[EMAIL PROTECTED]]
>Sent: Monday, April 16, 2001 8:53 AM
>To: [EMAIL PROTECTED]
>Subject: Re: Re[2]: [PHP-WIN] MySql pconnect
>
>
>As expressed in the article, the question is what the database
>was designed to actually "do".
Well. Dear Plutark. The author are talking about a design of an INSTANCE
in the database in this case, not about the RDBMS it self - which I were
talking about.
>MySQL creates quick connections, responds to SELECT statements as fast as
>anything can, has a small footprint, and does not require any special fees
>to use it. And yes, it's open source. For the vast majority of web sites,
>MySQL is an absolutely perfect fit.
I have hard to see how this speed issues could be related to the
fact that MySQL does not provides you with stored procedures?
In what way do you suggest to say that a SELECT statment or an allocation
of a connection would be slower just because the RDBMS provides you with
stored procedures? Please explain...
>But if you are a bank or running a real-time game that requires player data
>to be saved constantly, for instance, something like Oracle is what you'll
>need (for now).
You can use any RDBMS with sufficient functionality to do that "banking
thing".
It is "just" a matter of planning strategies for your design of your
database
system and the database schema of that database system.
>But most people just don't _need_ transactions. However, MySQL is planning
>to add support for such things in later versions. You have to keep in mind
>that MySQL is new compared to Oracle. It makes sense that it has a smaller
>amount of features.
Who did mention Oracle? I didn't.... My original statment was:
"MySQL is even a worse RDBM's than I thought"
Anyhow: If I want to run Formula-1, then I don't buy a Vas Lada, just
because
most people don't want to run fast. Just because "most people just don't
_need_ transactions", doesn't implies that MySQL is a good RDBMS! And that's
my
point! MySQL is not a suitable RDBMS system in general, and from that point
I made my conclusion stated above.
>And on an unrelated issue, down with bloatware :)
Excuse an ignorant person, but I didn't get that one?
I am using following code to upload files to server. But it gives error. I
am using Windows 2000 Server / IIS 5.0
Please give advice.
>>
@copy($sourcefile, $path . "/" . $file_name);
$sourcefile is defined in form submition
as
<INPUT NAME="$sourcefile" TYPE="file">
Hi,
uploading of file via form is described in chapter 19 of PHP documentation.
Look there for more explanation and examples.
But the source of error in your case is probably because of incorrect name of
NAME field in the form. It should be <INPUT NAME="sourcefile" TYPE="file">
not <INPUT NAME="$sourcefile" TYPE="file">. Don't use "$" - put only the name
of the variable.
Let me know if it helped you. Greetings
Piotr
Cenker Sisman wrote:
> I am using following code to upload files to server. But it gives error. I
> am using Windows 2000 Server / IIS 5.0
>
> Please give advice.
>
> >>
>
> @copy($sourcefile, $path . "/" . $file_name);
>
> $sourcefile is defined in form submition
> as
> <INPUT NAME="$sourcefile" TYPE="file">
>
> --
> PHP Windows 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]
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
Hello everyone,
I've installed the Apache Webserver 1.3.19 on Win98 and the Php4.
I think that I have installed the dll files and configured the Apache conf
files properly but each time I want to run a php- file I get the error
message: "couldn't spawn child process" in my Apache error log and a 500
Internal Server Error.
What is wrong? I hope someone also knows the problem and can help me!
Anders
Hi there.Until now i have successfully store my images as blob in mysql . However I
have seen that many others choose another aproach that is storing only the image
reference. I have tried this ,but I have yet to accomplish this.
All the example i have seen are based on unix /linux OS which means the paths are
differernt from undre windows.
I am not sure how to this :
I want to be able to store images in a fold
c:programfiles\apach group\apache\htdocs\images
i realize i have to copy the the temp file to this path but I was hoping is someone
could help me with an example
Thanks all
This forum rocks
lars Eirik
Warning: fopen("U:\filename.txt","w+") - Permission denied in D:
\wwwroot\somepath\more\thescript.php
I'm having this terrible problem writing a file to a drive that is mapped
by the server. I'm not even sure its a PHP problem, but my perl scripts
don't seem to have any trouble with it.
IIS 5, PHP 4, Win2k
The script runs under a virtual directory that has NT Authentication
checked, Anonymous Access unchecked [so the REMOTE_USER server variable is
available to the php scripts]. The drive is mapped to a folder on another
server that gives Guest and Everyone "Full Control". If you run the script
from the server [from the servers web browser], it works perfectly. The
server is logged in as Domain Admin, but no matter how I try to access the
script from a workstation - even as Domain Admin, I still get an error. I
am able to write files to the mapped directory from a workstation using
explorer. When Anonymous Access is on, it works fine but I am unable to
use the REMOTE_USER variable.
Is there a way to write files to a mapped directory with "Anonymous Access"
turned off?
Thanks in advance,
-Paul Wieland
Hello All,
I am looking for an API to access a mysql server from a Java applet running
on a client (via a web site).
I found the mm.mysql.jdbc api on the mysql.com site.
Are there other api implementations available for Java?
Is the "stable version" mm.mysql.jdbc 2.0.4 the best choice and the best
api to use?
Is there a really simple example, like connect, select, list results, to
get one started?
I am developing on Win98/NT using JBuilder from Borland.
Thanks much,
Barry.
If the mail() function returns FALSE indicating failure, I would like to
fail over to an alternate SMTP server. But, the smtp server is specified in
the php.ini file, not as a parameter to the mail() function.
Any ideas?
Monty
