On Thu, 2005-02-17 at 10:12 -0500, [EMAIL PROTECTED] wrote: > Does anyone have a recommendation as to which solution would be more > optimal, both for space and processing time? In a worst case > scenario, I could insert over 1 million polygons, resulting in a max > 20 million point list table. >
I think storing the points in a BLOB will likely be much faster and more compact too. The downside is that you cannot query for polygons by point values (unless, perhaps, you create some custom SQL functions to scan the BLOBs.) -- D. Richard Hipp <[EMAIL PROTECTED]>