speed up compile

[Claes]

Hi all,

My problem is that it takes 30-40 minutes to compile the client code(windows). Server side only takes about 30 sec(unix with database and appserver).

If I install a local db and compile the client code on that machine it goes from 30-40 min to about 30 sec. Further I've also minimized the propath but to no measurable decrease in compile time.

Is there some way to speed up the compile? Or do I just have to live with slow compiles?

Best regards Claes

 

[Stefan]

If compiling with a local database connection is much faster, then compile with a local database.

You should be able to automatically create a local copy of the database using the following steps:

1. connect to database
2. dump schema (
3. disconnect from database
4. create new database
5. load schema

Another option could (I have never tried this) be to use a local schema cache, see the -cache parameter in the help, you first need to create the cache using SAVE CACHE (just tried this and it took about 2 minutes to create a local cache of our 600 table database over a 20 mbit internet connection).

Since the compile only needs the database for the schema, I would expect that using a cache should result in the same performance as when compiling with a local database.