php-windows Digest 20 Sep 2002 04:38:43 -0000 Issue 1348
Topics (messages 15909 through 15921):
Re: Pictures as files or text/blobs
15909 by: David Hollister
15920 by: Tracker1
15921 by: Tracker1
Re: long admin processes. script timeout.
15910 by: William
Simple Question
15911 by: Kit Kerbel
GD 2.0.1
15912 by: Lanham Rattan
on W2K server
15913 by: yasin inat
15914 by: Dash McElroy
15916 by: Olivier Hubert
zlib extension ?
15915 by: Wolfgang Schneider
15917 by: David Hollister
15919 by: Wolfgang Schneider
Test
15918 by: +Alibi_
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]
----------------------------------------------------------------------
--- Begin Message ---
It depends on the DB platform, but generally a select query returns a
limited text size. To return the whole BLOB you have to get into pointers
and reading in chunks. So from the perspective of select *, I don't think
it's a problem.
But I think your intuition is right on; the database is a bad place for this
kinda stuff. The database is not meant to be a file repository. The
database is intended for fast indexing of information. And while you can
argue that BLOBS in one table shouldn't affect the performance of indexing
of other tables, you should be considering the overall cost of management.
Simple things like moves, replication and backups become difficult.
Furthermore, the BLOBS themselves are not indexed, only referenced.
Just my 2 cents -
Dave
-----Original Message-----
From: Rich Gray [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 6:07 AM
To: Luis Ferro; [EMAIL PROTECTED]
Subject: RE: [PHP-WIN] Pool: Pictures as files or text/blobs
Luis
FWIW...
I would always choose storing the URL to the image in the database over
storing the binary image in a text/blob field....
I can't back up my choice with hard evidence - just a gut feeling that an
injudicious 'select * from blobtable' would probably cripple the server
performance wise
Has anyone done any tests? I'd be interested to see the results and be
proven wrong if necessary!
Cheers
Rich
-----Original Message-----
From: Luis Ferro [mailto:[EMAIL PROTECTED]]
Sent: 19 September 2002 11:55
To: [EMAIL PROTECTED]
Subject: [PHP-WIN] Pool: Pictures as files or text/blobs
From a performance wise point of view... what is preferable:
a) placing pictures in blob/text fields in binary...
b) placing the picture name/directory in a varchar field and the picture
as a file in the refered directory...
What would you choose and why?
Thanx and cheers...
Luis Ferro
TelaDigital.Net
---
[This E-mail scanned for viruses by Declude Virus]
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
using the filesystem to store the file.. *UNLESS* you are processing
the image via php for security... the webserver can deliver an image
from the filesystem, especially with caching faster than via the db.
also, with less memory overhead.
Luis Ferro wrote:
> From a performance wise point of view... what is preferable:
>
> a) placing pictures in blob/text fields in binary...
> b) placing the picture name/directory in a varchar field and the picture
> as a file in the refered directory...
>
> What would you choose and why?
--
-----------------------------------------------------------------------
Michael J. Ryan | ICQ: 4935386
tracker1(at)theroughnecks(dot)net | AIM/AOL: azTracker1
Roughneck BBS: | Yahoo: azTracker1
http://www.theroughnecks.net | MSN: (email address)
telnet://theroughnecks.net | Trillian: www.trillian.cc
--- Synchronet 3.10j-Win32 NewsLink 1.30
* Roughneck BBS - www.theroughnecks.net - telnet://theroughnecks.net
--- End Message ---
--- Begin Message ---
I've done some testing, on better rdbms' it can work about as well,
and if you process the output, ie, you do a security check on the
request, and return the file, the db can be faster since it needs to
be processed anyways... but the webserver can "puke out" files faster
than the db can deliver from filesystem/cache to the server/script
and out.
Rich Gray wrote:
> Luis
> FWIW...
> I would always choose storing the URL to the image in the database over
> storing the binary image in a text/blob field....
> I can't back up my choice with hard evidence - just a gut feeling that an
> injudicious 'select * from blobtable' would probably cripple the server
> performance wise
> Has anyone done any tests? I'd be interested to see the results and be
> proven wrong if necessary!
> Cheers
> Rich
> -----Original Message-----
> From: Luis Ferro [mailto:[EMAIL PROTECTED]]
> Sent: 19 September 2002 11:55
> To: [EMAIL PROTECTED]
> Subject: [PHP-WIN] Pool: Pictures as files or text/blobs
>
>
> From a performance wise point of view... what is preferable:
>
> a) placing pictures in blob/text fields in binary...
> b) placing the picture name/directory in a varchar field and the picture
> as a file in the refered directory...
>
> What would you choose and why?
>
> Thanx and cheers...
> Luis Ferro
> TelaDigital.Net
>
>
> ---
> [This E-mail scanned for viruses by Declude Virus]
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
--
-----------------------------------------------------------------------
Michael J. Ryan | ICQ: 4935386
tracker1(at)theroughnecks(dot)net | AIM/AOL: azTracker1
Roughneck BBS: | Yahoo: azTracker1
http://www.theroughnecks.net | MSN: (email address)
telnet://theroughnecks.net | Trillian: www.trillian.cc
--- Synchronet 3.10j-Win32 NewsLink 1.30
* Roughneck BBS - www.theroughnecks.net - telnet://theroughnecks.net
--- End Message ---
--- Begin Message ---
That's just what I needed.
Thanks
"Richard Black" <[EMAIL PROTECTED]> wrote in message
006f01c25ffa$5002aad0$0900a8c0@DVLAPTOP1">news:006f01c25ffa$5002aad0$0900a8c0@DVLAPTOP1...
> The set_time_limit() function can be used to stop your script from
> timing out, without having to change your php.ini file and give all
> scripts a huge time limit.
>
> http://www.php.net/manual/en/function.set-time-limit.php
>
> As for performance of other users... Probably depends on what is making
> the script take so long. Without knowing what it does, or seeing the
> code, it's kinda hard to say what you can do to optimize it...
>
> HTH,
>
> Richy
>
> ==========================================
> Richard Black
> Senior Developer, DataVisibility Ltd - http://www.datavisibility.com
> Tel: 0141 951 3481
> Email: [EMAIL PROTECTED]
>
> -----Original Message-----
> From: William [mailto:[EMAIL PROTECTED]]
> Sent: 19 September 2002 18:33
> To: [EMAIL PROTECTED]
> Subject: [PHP-WIN] long admin processes. script timeout.
>
>
> I have an application that needs to perform some large processes, moving
> data as well as generating some rather large output files. This process
> might take about 15 to 20 minutes to complete and "MUST" be completed.
> It is only run by 1 administrator every and not a general user.
>
> 1)Is there anything I should do to adjust this script to optimize/ensure
> it doesn't time out before finished?
>
> 2)Will a long process like this keep the general users from using the
> system?
>
> Thanks,
> william
>
>
>
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
> ________________________________________________________________________
> This email has been scanned for all viruses by the MessageLabs SkyScan
> service. For more information on a proactive anti-virus service working
> around the clock, around the globe, visit http://www.messagelabs.com
> ________________________________________________________________________
>
--- End Message ---
--- Begin Message ---
This is a simple question:
I'm trying to upload files using php. I'm pretty sure I've got that part
down. However, I am trying to upload pics inside the same form which posts
other information, not of "FILE" type. This doesn't seem to be working.
Does the html enctype have anthing to do with it? the pic upload works fine
by itself. do I need to separate the forms, or is there a way to reference
the other values with enctype="multipart/form-data"?
Thanx in advance,
Kit
_________________________________________________________________
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx
--- End Message ---
--- Begin Message ---
I upgraded to the latest PHP and now I think my graphics library is broke.
I was told to get GD 2.0.1, is there a .dll or something?
Lanham.
--- End Message ---
--- Begin Message ---
i've read all about documentation php -sapi module- on apache2
but i couldn't take result of any success ...
i've disabled IIS .... want to use apache2 instead of it ....
i've downloaded apache2.036 , 2.0.39 , 2.0.40
& php 4.2.1 , 4.2.2
i've tried all compositions of them above .... but nothing ...
only the error like this
The Apache service named reported the following error:
>>> Cannot load C:/PHP/php4apache2.dll into server: The specified module could not be
>found
>>> Cannot load C:/PHP/php4apache.dll into server: The specified module could not be
>found (even i've tried php4apache.dll)
pls help me ....
--- End Message ---
--- Begin Message ---
I've got Apache 2.0.40 and PHP 4.2.3 running just fine as a sapi on my win2k
pro box.
Possible reasons:
1. Apache 2.0.40 and PHP4.2.3 like each other, as do 2.0.39 and php 4.2.2
(but don't mix and match).
2. The path to your sapi plugin is incorrect (mine is at
c:/php/sapi/php4apache2.dll).
-Dash
-----Original Message-----
From: yasin inat [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 9:11 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: [PHP-WIN] on W2K server
i've read all about documentation php -sapi module- on apache2
but i couldn't take result of any success ...
i've disabled IIS .... want to use apache2 instead of it ....
i've downloaded apache2.036 , 2.0.39 , 2.0.40
& php 4.2.1 , 4.2.2
i've tried all compositions of them above .... but nothing ...
only the error like this
The Apache service named reported the following error:
>>> Cannot load C:/PHP/php4apache2.dll into server: The specified module
could not be found
>>> Cannot load C:/PHP/php4apache.dll into server: The specified module
could not be found (even i've tried php4apache.dll)
pls help me ....
--- End Message ---
--- Begin Message ---
Hi,
I've had the same kind of problem, I don't know if what I propose will
solve yours (my error message was "The specified procedure could not be
found"). First of all, make sure your paths are all right and that you
copied the php4ts.dll in the good windows directory.
If you still have a problem, try downloading PHP from:
http://snaps.php.net/win32/php4-win32-latest.zip
I checked the link just before sending this mail and it was still working.
Using the php4apache4.dll from this package solved my problem and allowed
me to use PHP as an ISAPI module with Apache2.
Olivier Hubert
Note: thanks go to Stuart Hamilton ([EMAIL PROTECTED]) who first sent this
link to the PHP-WIN mailing list
At 21:10 2002-09-19 -0700, yasin inat wrote:
>i've read all about documentation php -sapi module- on apache2
>
>but i couldn't take result of any success ...
>i've disabled IIS .... want to use apache2 instead of it ....
>
>i've downloaded apache2.036 , 2.0.39 , 2.0.40
>& php 4.2.1 , 4.2.2
>
>i've tried all compositions of them above .... but nothing ...
>
>only the error like this
>
>The Apache service named reported the following error:
>
> >>> Cannot load C:/PHP/php4apache2.dll into server: The specified module
> could not be found
>
> >>> Cannot load C:/PHP/php4apache.dll into server: The specified module
> could not be found (even i've tried php4apache.dll)
>
>
>
>pls help me ....
--- End Message ---
--- Begin Message ---
Hello,
I am trying to install an php/mysql application which has an
automatic install routine ... however, while running it, it checks
for installed components and came up with the following message
concerning a missing extension ...
>> For Claroline to work, you need the following on the server :
>>
>> * Webserver (you have Apache/1.3.23 (Win32)
>> * with PHP 4.x, (you have PHP 4.1.2)
>> o zlib is !!missing!!
Can someone tell me what this could be about? ZLIB seems to be a php
extension and on my win2k machine there should be a dll file for
this?
I found a website and downloaded the zlib.dll ... but where do I now
save it to? the php/dlls/ folder? a folder in the /winnt/ folder
tree? Will I need to edit the php.ini file as well to get this
working?
Any input is greatly appreciated, especially since I am not as
familair with reading the type of documentation provided on the
websites for this zlib extension :-)
God bless you with His grace and peace
Wolfgang
Looking for Biblical information? COME AND SEE!
-- ONLINE Courses: http://classes.bibelcenter.de ... NEW!
-- BibelCenter: http://www.bibelcenter.de
-- Bookstore: http://www.worthy.net/BibelCenter/
--- End Message ---
--- Begin Message ---
>>Looking for Biblical information? COME AND SEE!
Hey, isn't that the line that catholic priests use to get kids alone?
-----Original Message-----
From: Wolfgang Schneider [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 1:32 PM
To: [EMAIL PROTECTED]
Subject: [PHP-WIN] zlib extension ?
Hello,
I am trying to install an php/mysql application which has an
automatic install routine ... however, while running it, it checks
for installed components and came up with the following message
concerning a missing extension ...
>> For Claroline to work, you need the following on the server :
>>
>> * Webserver (you have Apache/1.3.23 (Win32)
>> * with PHP 4.x, (you have PHP 4.1.2)
>> o zlib is !!missing!!
Can someone tell me what this could be about? ZLIB seems to be a php
extension and on my win2k machine there should be a dll file for
this?
I found a website and downloaded the zlib.dll ... but where do I now
save it to? the php/dlls/ folder? a folder in the /winnt/ folder
tree? Will I need to edit the php.ini file as well to get this
working?
Any input is greatly appreciated, especially since I am not as
familair with reading the type of documentation provided on the
websites for this zlib extension :-)
God bless you with His grace and peace
Wolfgang
Looking for Biblical information? COME AND SEE!
-- ONLINE Courses: http://classes.bibelcenter.de ... NEW!
-- BibelCenter: http://www.bibelcenter.de
-- Bookstore: http://www.worthy.net/BibelCenter/
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
On Thu, 19 Sep 2002 15:04:31 -0500, David Hollister wrote:
>>>Looking for Biblical information? COME AND SEE!
>
>Hey, isn't that the line that catholic priests use to get kids alone?
Mr. Hollister,
save your jokes for some other place .. disgustiung!
And, yes .. I rather you not reply!
Sincerely,
Mr. W. Schneider
--- End Message ---
--- Begin Message ---
Testing..
__________________________________________________________________ anthony
Shapley ICQ#: 167013817 Current ICQ status: + More ways to contact me
__________________________________________________________________
--- End Message ---
