Latest Contributions by VinceAngelo

I can't think of a single application I've ever written that needed a full table scan for every query (and didn't know exactly what attributes would be needed). FGDB would be much faster than shapefile with a spatial subset, but because of your particular requirements, shapefile format is going to be your best option. - V ... View more

If you're searching with 100 meter squares, you might want to shrink your index grid to 300-500m, just to reduce the number of false positives. My laptop generates 300ms results on a smilar query with the 'C' API and an application server connection... Are you using an application server or Direct Connect? How many columns are you returning? What are their types? Are any large BLOBs involved? How long does the same query take using a 'C' client ('sdequery' of se_toolkit can perform 'C' API searches from the command-line)? - V ... View more

My son's doing fine now, thanks. There is no reason to iterate the attribute list if you don't need the attributes.  I doubt it's required even if you do select all the columns, but I know it's not required if you select only the geometry column in the Search request that generates the EnumRows iterator. (If nothing else, you should specify the geometry column first.) File Geodatabase format uses a compression algoritm on the geometries, but if the "a000*.gdbtable" that corresponds to your table is larger than the .shp on the shapefile, there is no chance for the FGDB to be faster in a full-table scan query (and even if it is smaller, there's still the decompression cost to factor into the equation). I'd recommend you modify the Search, then instrument your code with a millisecond resolution timer, so you can see where the application is spending its time while reading in the two different formats. - V ... View more

Most spatial datasets are too large to mail successfully, but if the resulting zip file is < 6Mb, then it should transfer cleanly. I've had issues with WinZip performing nl->cr,lf conversion on binary data on extract, or not preserving the directory structure, but even these are unfortunate settings in the extraction utility, and nothing to do with the data itself.  Try using 7Zip , which is a free and fast zip generation and extraction utility. - V ... View more

You haven't provided your code, and I haven't done performance benchmarking on FGDBAPI, but I'm willing to wager my son (with a 103.5 fever and cranky as all get-out) that the real cost is in reading the row from disk, not in the accessor function to copy the row members from memory. I'm quite fond of the ArcSDE 'C' API which uses row accessor functions *or* bind variables -- It's so much cleaner to organize a "copy" as: while ((sr = SE_stream_fetch(stream1))== SE_SUCCESS) {     if ((sr = SE_stream_execute(stream2)) != SE_SUCCESS) {         /* handle write error */ }    } if (sr != SE_FINISHED) {     /* handle read error */ } but the accessor design pattern is well-established (especially in Java, where bind variables are considered poor form). The only time that accessor functions are really inefficient is when transferring large BLOBs (and CLOBs, NCLOBs,..., and geometries). The majority of your cost difference is in the fact that you're *not* reading the .dbf component (and therefore doing half the I/O). You can certainly file an enhancement request for an alternate method to access the row buffer, but since ArcGIS doesn't even use bind variables with ArcSDE, it's probably going to be a hard sell. - V ... View more

Environment variables are honored by the SE_connection_create function, but not by the ArcGIS GUI.  In any case, it is probably unwise to put authentication information in a user's environment, allowing any application run on the host to misappropriate it. There are scripts available to rewrite connection information, though this is a lot less effort than reinstalling Oracle on that many hosts. - V ... View more

I don't work in Tech Support, so I'm certainly not the best resource for follow-up on incidents. Virtually all the tuning to be done with ArcSDE is at the database level (or higher). Most the tuning which is available at the ArcSDE level is in the transport buffers (and I've never made a change to them that improved performance). - V ... View more

Five seconds doesn't sound slow to do a full table scan on 500Mb of data.  Can you provide the code you're using in both cases? There are a number of advantages of file geodatabases over shapefiles, among them: + Support for numeric nulls + Second resolution date type (vice day resolution of dBase) + Variable width attribute rows (vice dBase fixed-width) + Unlimited width string fields (vice 254 in dBase) + 64 character attribute field names (vice 11 in dBase) + Full support for all types supported by ArcGIS (NSTRING, UUID, CLOB, NCLOB) + SQL query access + Open access to spatial and attribute index queries - V ... View more

What are you using to read the shape file? What is "~5sg"? Is the data point, line, or polygon? How large is the file that corresponds to the table in the FGDB?  How large are the .shp and .dbf files of the shapefile? Are you saying that you cache 500K rows of geometry in RAM, and only access attributes when you need them?  What is your access criteria? - V ... View more

The best way to receive updates is to contact Tech Support and start an incident. There are quite literally hundreds of ways to tune ArcSDE performance, but if you are experiencing a software issue, then it might not make a difference. - V ... View more

It's a trivial task with a number of combinations of Esri products.  Which ones do you have available?  What are you going to do with it once it's in the database? - V ... View more

The 1.0 general release of the FileGDB API has been up since early June. There are four release bundles: Windows VisualStudio 2008 (32- & 64-bit), Windows VisualStudio 2010 (32- & 64-bit), 32-bit Linux, and 64-bit Linux. - V ... View more

It's good practice to never delete previous information in configuration files, but to prevent conflict it needs to be commented out.  Adding a parse engine to look for lack of conflict is overkill. - V ... View more

If you have the needed information in the table, then Joe's description of how to use an ORDER BY clause should suffice; you just need to determine if you want North->South ordering (DESCending) or South->North (ASCending), and if you want latitude-major or longitude-major ordering. If you want ordering by map page, you'd need to either add a page column to the table or do the math to simulate one -- ORDER BY (trunc((lon+180) / 60)*6 + trunc((180-lat)/30)),lon,lat DESC [longitude major, N->S, with 36 pages 60deg x 30deg] - V ... View more

The main problem with updating web-based documentation is that links will occassionaly be broken by edits.  In the future you can submit feeback on the documentation by going to help.esri.com and clicking on Feedback at the bottom of the page (or going directly to the feedback page) and entring the URL of the page with the broken link, with a description of the link that failed (e.g., "linking from 'Creating an ArcSDE service from a remote Windows server' in step 12 generates a 'Document not Found' error").  Given that the link was working on Wednesday, it shouldn't be too difficult for the maintainer to figure out what edit broke it. - V ... View more