Hi Darius,
Just an idea: can you cut the binary data into separate small(er) chuncks
and then store it in different records? (Using some identifier to know
which chunks belong together, what is their order,...) This may make data
handling harder, but you can reduce the memory load of the server; you do
not have to store a very large binary data in one single variable.
Regards,
Peter Szekszardi
PortoLogic Ltd.
Portal building, prime number generating, script hacking and more...
The prime number of the day is 364664071
On Fri, 30 Mar 2001, Darius Ivanauskas wrote:
> Hi,
> Thanks for your interest.
>
> Actualy i had alredy saw few examples in different client software
> implementations. But in all these examples they are using the same
> way: you must load entire file contents into a single variable, and
> in most cases you should use escaping sequences for binary data. Ant this
> method is scaring me. Because for realy BIG files you need HUGE amount of
> server's memory. (I care mostly about PHP implementation.) And i don't
> think that there is many database clients that support quries much bigger
> than 1MB (Im considering possibility to use other databases than
> MySQL). So, i'm looking the way when I can store binary data using
> smaller data chunks.
>
> Regards,
> --
> Darius Ivanauskas
>
> On Fri, 30 Mar 2001, Peter Szekszardi wrote:
>
> > Hi Darius,
> >
> > It depends on, what client softwer do you use... For example if you would
> > like to fill BLOBS from a perl script via DBI, you have to use parameter
> > binding. Could you give me some details?
> >
> > Regards,
> >
> > Peter Szekszardi
> > PortoLogic Ltd.
> > Portal building, prime number generating, script hacking and more...
> > The prime number of the day is 364664071
> >
> > On Thu, 29 Mar 2001, Darius Ivanauskas wrote:
> >
> > > Hello,
> > >
> > > Does anybody know, how to insert large amount of data
> > > (ex.: large binary files) into BLOB columns?
> > >
> > > Thanks,
> > > Darius Ivanauskas
> > >
> > > P.S. Please reply to me.
> > >
> > >
> >
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
