List:General Discussion« Previous MessageNext Message »
From:William IT Date:May 21 2003 5:12am
Subject:Re: MySQL ODBC Can't Handle 4000 records contains BLOB
View as plain text  
I got idea from TheMechE (don't know his/ner name). He/She told me to
redesign my app. I think this is good idea. I am now trying to exclude the
BLOP field to .jpg file.


----- Original Message -----
From: "Curtis Maurand" <curtis@stripped>
To: "William IT" <william@stripped>
Cc: <mysql@stripped>
Sent: Wednesday, May 21, 2003 12:21 PM
Subject: Re: MySQL ODBC Can't Handle 4000 records contains BLOB


>
> According to the docs, you can use the dynamic cursor as of 3.51.01.  If
> your blob is large, you'll take up a lot of memory on the client having it
> store all 4,000 of the rows.  You can enable the option from the manual
> settings or you can pass OPTION=32 as the connection string.  Of course
> all of this is in the manual.  The performance issue you are having is
> with the ODBC driver, not MySQL itself.  Make sure tracing is turned off
> as well as the query log.
>
> Those are thoughts that I can find on the website.  I don't use windows
> too much for this sort of thing.
>
> Curtis
>
> On Wed, 21 May 2003, William IT wrote:
>
> > MyODBC version 3.51.06
> > MySQL version 3.23 on RedHat Linux 9.0 on P4-1800 MHz, 512 DDR and HDD
80
> > GB, swap file is 5 GB.
> > Delphi version 7.0
> >
> > I hope can use MySQL to replace MS SQL to save my money.
> >
> > ----- Original Message -----
> > From: "Curtis Maurand" <curtis@stripped>
> > To: <william@stripped>
> > Cc: <mysql@stripped>
> > Sent: Wednesday, May 21, 2003 12:24 AM
> > Subject: Re: MySQL ODBC Can't Handle 4000 records contains BLOB
> >
> >
> > >
> > > Which version of the ODBC driver are you using?
> > >
> > > Curtis
> > >
> > > William IT said:
> > > > After read your article and MyODBC FAQ, I just know that MySQL
doesn't
> > > > support server side cursor with static/keyset/dinamic cursor. Its
works
> > > > fine when I use Forward only cursor but I need to navigate my
Employee
> > > > Database in "Previous" and "Next" record operation. This forward
only
> > > > cursor very slow compare to MS SQL 2K.
> > > >
> > > > In this case I found MySQL not faster than MS SQL 2000 even MySQL
site
> > > > says: faster database avaiable compare to PostgeSQL and mSQL. I
already
> > > > try PostgreSQL and have this problem too.
> > > >
> > > > So, for this time being I must back to MS SQL and next month prepare
> > > > some budget to buy MS SQL 2000 Licence and of course buy a licence
for
> > > > the W2K Server :(
> > > >
> > > >
> > > > ----- Original Message -----
> > > > From: "Mike Hillyer" <mhillyer@stripped>
> > > > To: "William IT" <william@stripped>;
> <mysql@stripped>
> > > > Sent: Tuesday, May 20, 2003 10:06 PM
> > > > Subject: RE: MySQL ODBC Can't Handle 4000 records contains BLOB
> > > >
> > > >
> > > > Well I do not use delphi, but I do use Vb with MyODBC and ADO and
here
> > > > are tips I can give for large BLOB tables, hopefully you can port
them
> > > > to Delphi.
> > > >
> > > > Use a Server Side Forward-Only Cursor with a ReadOnly lock and
MyODBC
> > > > Option 1048576 turned on. This will cause MySQL to send only one row
at
> > > > a time to the client, and with the read-only lock that row will be
> > > > discarded before the next one comes down. Also, make sure MyODBC
option
> > > > 8 is turned on to allow large BLOB results to be sent and check your
> > > > Max_allowed_packet setting on the MySQL server to be sure it can
send
> > > > the size of blob you want to send.
> > > >
> > > > Hope That Helps,
> > > >
> > > > Mike Hillyer
> > > > www.vbmysql.com
> > > >
> > > >
> > > > -----Original Message-----
> > > > From: William IT [mailto:william@stripped]
> > > > Sent: Monday, May 19, 2003 6:30 PM
> > > > To: mysql@stripped
> > > > Subject: Re: MySQL ODBC Can't Handle 4000 records contains BLOB
> > > >
> > > >
> > > > MyOLEDB:
> > > > ------------
> > > > As you wish Martin, I download and install MyOLEDB version 3, but
> > > > MyOLEDB
> > > > only work with table without BLOB field.
> > > > When I try to connect Delphi 7 Dataset to table without BLOB field
is
> > > > ok,
> > > > but when connect to table with BLOB an error occurs: "table doet not
> > > > exits"
> > > > (my table name is: biodata), funny ha?
> > > >
> > > > MyODBC
> > > > -----------
> > > > MyODBC ver 3.51.06 work fine and faster than MyOLEDB, BUT have
problem
> > > > when
> > > > I use Delphi 7 - Dataset with USE SERVER SIDE CURSOR, an error
occurs:
> > > > "Access violation at address 1F453E6E in module 'msado15.dll'. Write
of
> > > > address 051D100C".
> > > > I must use Delpi Dataset Server Side Cursor because the Table very
big
> > > > (900
> > > > MB, contains 4000 rows and 1 BLOB field for storing employee
picture).
> > > > I have no problem before when I use MS SQL and Delphi 7, and I think
> > > > the problem come from MySQL MyODBC.
> > > >
> > > > Any one can help me?
> > > >
> > > >
> > > > ----- Original Message -----
> > > > From: "Martin Gainty" <mgainty@stripped>
> > > > To: "William IT" <william@stripped>;
> <mysql@stripped>
> > > > Sent: Sunday, May 18, 2003 9:11 AM
> > > > Subject: Re: MySQL ODBC Can't Handle 4000 records contains BLOB
> > > >
> > > >
> > > >> Just to be clear-
> > > >> You are doing an ADO connection access  using an ODBC Database
Driver?
> > > >> Martin
> > > >> ----- Original Message -----
> > > >> From: "William IT" <william@stripped>
> > > >> To: <mysql@stripped>
> > > >> Sent: Sunday, May 18, 2003 8:34 PM
> > > >> Subject: MySQL ODBC Can't Handle 4000 records contains BLOB
> > > >>
> > > >>
> > > >> I have serious problem when  try to convert MS SQL to MySQL.
> > > >>
> > > >> My MS SQL Server contain 4000 (four thousand) rows with toyal
> size
is
> > > > 1.3
> > > >> GB. This big database cause by one BLOB field, I strore picture
> in
> > > > this
> > > >> database. I am using P4-1800 MHz, 512 DDR and HDD 80 GB on RedHat
> 9
> > > > using
> > > > 5
> > > >> GB Swap memory!.
> > > >> Client on Windows 2000 using PIII-700, 128 SDRAM, and HDD 20 GB,
swap
> > > > memory
> > > >> file is 2 GB!
> > > >>
> > > >> First, I successfully convert MS SQL to MySQL using SQLyog in
> just
> > > > minutes.
> > > >> BUT, when I access MySQL using Delphi+ADO problem occurrs: "Error
read
> > > >> stream data" and "Low Memory". Delphi+ADO takes very longer time
> ti
> > > > access,
> > > >> 10 times than MS SQL!!!
> > > >> There is no problem before when I am using MS SQL. So, I think
> this
> > > > error
> > > >> caused by MySQL ODBC 3.51 Driver.
> > > >>
> > > >> Anyone can help me?
> > > >>
> > > >> --
> > > >> MySQL General Mailing List
> > > >> For list archives: http://lists.mysql.com/mysql
> > > >> To unsubscribe:
http://lists.mysql.com/mysql?unsub=1
> > > >>
> > > >
> > > >
> > > > --
> > > > MySQL General Mailing List
> > > > For list archives: http://lists.mysql.com/mysql
> > > > To unsubscribe:
> > > > http://lists.mysql.com/mysql?unsub=1
> > > >
> > > >
> > > > --
> > > > MySQL General Mailing List
> > > > For list archives: http://lists.mysql.com/mysql
> > > > To unsubscribe:
> > > > http://lists.mysql.com/mysql?unsub=1
> > >
> > >
> > >
> > >
> > > --
> > > MySQL General Mailing List
> > > For list archives: http://lists.mysql.com/mysql
> > > To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
> > >
> >
>
> --
> --
> Curtis Maurand
> mailto:curtis@stripped
> http://www.maurand.com
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>

Thread
MySQL ODBC Can't Handle 4000 records contains BLOBWilliam IT19 May
  • Re: MySQL ODBC Can't Handle 4000 records contains BLOBMartin Gainty19 May
  • Re: MySQL ODBC Can't Handle 4000 records contains BLOBWilliam IT20 May
RE: MySQL ODBC Can't Handle 4000 records contains BLOBMike Hillyer20 May
  • Re: MySQL ODBC Can't Handle 4000 records contains BLOBWilliam IT20 May
    • Re: MySQL ODBC Can't Handle 4000 records contains BLOBCurtis Maurand20 May
    • Re: MySQL ODBC Can't Handle 4000 records contains BLOBWilliam IT21 May
      • Re: MySQL ODBC Can't Handle 4000 records contains BLOBCurtis Maurand21 May
        • Re: MySQL ODBC Can't Handle 4000 records contains BLOBWilliam IT21 May
RE: MySQL ODBC Can't Handle 4000 records contains BLOBDave Christensen21 May