[dba-Tech] MySQL gurus

[Gustav Brock]

Hi John

Ah, now I get the picture. 
It sounds very likely that the ODBC route turned out to be the fastest and simplest.

/gustav

________________________________________
Fra: dba-Tech <dba-tech-bounces at databaseadvisors.com> på vegne af John R Bartow <jbartow at winhaven.net>
Sendt: 26. november 2015 18:20
Til: 'Discussion of Hardware and Software issues'
Emne: Re: [dba-Tech] MySQL gurus

Lol!

Sorry Gustav,
I was not doing that. What I have is an inventory of client assets via my
online RMS and I have a choice of how to search for information.

One is via HTML report - which was an awful way to do it, there was just too
much data and the browser took forever to search through it.

Another is XML dump. I this and that is also quite awful. I think it has to
do with the way the database is set up in the first place but there is
nothing I can do to change that.

Then I tried the sqldump. I had to use an SQL database to import the data as
I could not find a way to do that directly in Access. So I choose the MySQL
route. Which after overcoming the 32/64bit ODC Manager issue worked very
well. Maybe because I'm an old relational database guy and am familiar with
Access and so was able to overcome their DB design with queries.

I spent less time installing MySQL on the server, setting up the ODBC
connection, importing the data into MySQL and then into Access, creating a
query and finding the items I needed than what 3 searches took in the HTML
or XML files.

Reinforced my faith in relational databases :-)

Regards,
John

-----Original Message-----
From: dba-Tech [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of
Gustav Brock
Sent: Thursday, November 26, 2015 12:49 AM
To: Discussion of Hardware and Software issues
Subject: Re: [dba-Tech] MySQL gurus

Hi John

Eh ... how do you compare HTML with an ODBC connection? Seems totally
unrelated to me - like oranges and, say, coffee ...

/gustav

-----Oprindelig meddelelse-----
Fra: dba-Tech [mailto:dba-tech-bounces at databaseadvisors.com] På vegne af
John R Bartow
Sendt: 26. november 2015 04:45
Til: 'Discussion of Hardware and Software issues'
<dba-tech at databaseadvisors.com>
Emne: Re: [dba-Tech] MySQL gurus
Prioritet: Høj

It was all because I'm using 32 bit Access. Everything else involved was 64
bit (Windows, Windows Server, MySQL).
Had it been 64 bit Access everything would have worked fine.

So the lesson learned is use 32 bit ODBC drivers with Access regardless of
the data source.

As an aftermath though, I will say that the speed of the Access query I
developed after importing the data from MySQL is phenomenal compared to
trying to find it in HTML, RAW XML or XML Notepad.

Just to compare I think I'll make another Access DB with the data linked and
see if it's any faster.

Any bets on that?