Migrating a Access db

#1 (**permalink**) 02-28-2008, 09:10 AM

I am migrating an Access db to MySql. I am have some SQL's that reference
other SQL's within them. Can this be done in scripts? Some of the SQL's
are very large so keeping them seperate is a benefit. Also the initial sql
is used in many other sql's. Also....believe it or not...by combining the
sql's together, Access was slower returning the result.

#2 (**permalink**) 02-28-2008, 09:11 AM

> I am migrating an Access db to MySql. I am have some SQL's that reference
> other SQL's within them. Can this be done in scripts? Some of the SQL's
> are very large so keeping them seperate is a benefit. Also the initial sql
> is used in many other sql's. Also....believe it or not...by combining the
> sql's together, Access was slower returning the result.

I do believe that. Access stores its queries in a compiled form, so
referencing them will speed things up.
A stored query in Access is best compared to a "view" in MySQL. So if
you want to port the queries first, before cleaning them up, you'd
probably want to check out views. If things get too complicated for
views, you can always try stored procedures if your MySQL version
supports them.

Best regards
--
Willem Bogaerts

Application smith
Kratz B.V.
http://www.kratz.nl/

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode