Re: [PHP-DB] Image and Mysql capabilities

[Lokesh Wuluvarana]

In Oracle reports, this strategy is used (storing the path of the image
file in the DB and storing the actual image file in the OS) to display
images and for the same reason - performance of the DB. I think it is
good approach.
Lokesh

Felipe Moreno wrote:
> 
> Hi list Members,
> 
>I have a real doubt regarding the storage of images in the My sql
> database. Anyone know the alternatives to manipulate the insert and query
> with images? Well, let me explain...I have a lot of images that correspond
> to some "cars" names. I want, everytime a user select the respective car, to
> "bring" the respective car image with the informations of that car. I was
> reading about mysql, and found that it don't store images in the fields, but
> we can create a BLOB field and store it in binary. But, I'm afraid of the
> performance of the DB, cause sometimes you have thousands os images, and I
> know that it will occupy a lot of space!...So, I thought about putting a
> reference path to that image!...And print this path in a  tag...What do
> you think about it?
> 
> Thanks 4 your attention,
> 
> Regards,
> 
> Felipe Moreno
> 
> -Mensagem original-
> De: Mark Roedel [mailto:[EMAIL PROTECTED]]
> Enviada em: segunda-feira, 14 de maio de 2001 10:51
> Para: Dragan Dinic; [EMAIL PROTECTED]
> Assunto: RE: [PHP-DB] php -> MSSQL
> 
> > -Original Message-
> > From: Dragan Dinic [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, May 14, 2001 5:11 AM
> > To: [EMAIL PROTECTED]
> > Subject: [PHP-DB] php -> MSSQL
> >
> >
> > Is there any possible way to connect PHP (running on apache
> > 1.3.12 on Red Hat Linux 7) with Microsoft SQL server (running
> > on Windows 2000) ?
> 
> Yep.
> 
> As someone else has noted, the ODBC functions are one way.
> 
> Another way, particularly if you prefer to talk to the database directly
> rather than through a translation layer, is to install the FreeTDS
> libraries (http://www.freetds.org/) on your Linux machine and then build
> PHP with the --with-sybase configuration parameter.  This will enable
> the mssql_* functions.
> 
> ---
> Mark Roedel ([EMAIL PROTECTED])  ||  "There cannot be a crisis next week.
> Systems Programmer / WebMaster  ||   My schedule is already full."
>  LeTourneau University  ||-- Henry Kissinger
> 
> --
> PHP Database 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 Database 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 Database 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-DB] Performance of Stored Procedures ?

[Lokesh Wuluvarana]

Well tuned (using appropriate indexes and following a good execution
plan) Queries work faster than procedures. If the query involves
mathematical computation or operations such as substr, concatenations,
then a PL/SQL procedure works better. It all depends what the quey is
doing.

Lokesh

"Thies C. Arntzen" wrote:
> 
> On Mon, May 14, 2001 at 02:52:01PM +0200, Robert Boehrs wrote:
> > Hi,
> >
> > i've just made some simple test with oracle and stored procedures. I've used
> > a simple select-statement within the stored procedure and the same query for
> > a direct query within php.
> > The direct query was about 50% faster. Is that normal? Will the stored
> > procedures become faster with more complex queries?
> 
> this pretty much depends on the code you write.
> 
> could you send me the code you used for your "little"
> benchmark - so i could have a loot at it?
> 
> tc
> 
> --
> PHP Database 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 Database 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-DB] PHP and Oracle

[Lokesh Wuluvarana]

Hi,
I just wanted to know if there are any known issues with PHP working
with Oracle database. We are currently configuring Oracle to make PHP
work with Oracle. Let me know.
Thanks
Lokesh

-- 
PHP Database 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]