The basic stuff for my purpose is the gums.mw table,
described in http://dc.zah.uni-heidelberg.de/tableinfo/gums.mw
How to get to it:
what works: go to topcoat (download as needed)
and follow instructions in http://voparis-europlanet.obspm.fr/utilities/Tuto_TopCat.pdf
You don't get the file, but you can SQL-type query it.
You get 1.000.000 records easily, but I still have to figure out how
to get the whole file, e.g. as a binary fits.
Markus Demleitner at ARI is the person to talk to; here is what he advises:
Uncheck "synchronuous"; this selects async operation, which lets you even change your location and IP and retrieve the result later; also, it gives you, by default, 3600 seconds of query time before timing out. magg<17.5 is still a large number of objects and hence a very large table (I'd expect several 1e8 rows), probably too big for TOPCAT to keep in memory or to handle directly (though it might be ready before the 3600 s timeout). You could use STILTS to stream things to your disk and select FITS binary output (see stilts tapquery); but it'd certainly be preferable if you gave some additional constraints to offload part of your computation to the server (note that you can also upload your own object lists). The server already has indices in place, quite some memory, etc., so it usually pays to let it do the heavy lifting and keep the tables you actually deal with of order 1e6 or maybe 1e7 rows.
I am now working on downloading the fits file directly,and do them with p. in subdir GaiaSims in Apogee.