OpenEuphoria

Re: EuCom

• Posted by 10963508 at europeonline.com Jul 15, 2002
• 457 views

Thanks, looking forward to see it.
I am using your ODBC library but it's slow for what I'm doing, maybe you'll
have some tips how to speed this up:
I have table with 700 records.
If buffer size is default 2048 it takes 881 seconds (14 minutes!) to update
every record using code below. If I change buffer size to 10240 same code
takes 17.68 seconds! Great imporvement but I noticed hard drive does more
work now.

I have this function to test speed:

procedure test_odbc_speed ()
    atom t1
    object sr_data
    STRING guid

    sr_data = execDirectODBC (H_Fazzt_Conn, "SELECT * FROM
SelectiveReception")
    if not sequence (sr_data) then
        odbcError (-sr_data)
        return
    end if

    puts (1, "start test\n")
    t1 = time ()
    for i = 1 to length (sr_data) do
        guid = sr_data [i] [SR_GUID]
        Void = execDirectODBC (H_Fazzt_Conn,
            "UPDATE SelectiveReception SET Ignore = 2 WHERE (GUID = '" &
guid & "')")
    end for
    ? time () - t1
end procedure



----- Original Message -----
From: "Matthew Lewis" <matthewwalkerlewis at YAHOO.COM>
To: "EUforum" <EUforum at topica.com>
Sent: Monday, July 15, 2002 1:59 PM
Subject: RE: EuCom


>
>
> > -----Original Message-----
> > From: 10963508 at europeonline.com [mailto:10963508 at europeonline.com]
>
> > To Matt Lewis,
> > I wanted to use ADO to access .mdb files because it is
> > simpler and faster
> > than
> > ODBC.
> > With TBROWSE.EXE I generated msado15.ew for file C:\Program
> > Files\Common
> > Files\System\ado\msado15.dll.
> > I was really surprised it generated wrapper for me automatically.
> > I then run program which has only this line:
> > include msado15.ew
> > (I copied all include files from EuCom to my program's directory)
> > and it gives me this Windows error:
> > "The instruction at ... referenced memory at ... Memory could
> >  not be read
> > from."
> > I then tried it with another file, msadox.dll, and it
> > displayed the same
> > Windows error.
> > I am using WinXP, EuCom v2.0a.
> >
> > Matt, if you could fix this bug then EuCom would really be useful!
>
> Sorry, didn't check my email over the weekend.  I've never tried to wrap
ADO
> before (I've done Access itself, though).  I'll check this out and see
what
> I can come up with.  I'll also look into IE for you.
>
> Matt Lewis
>
>
>
>