I have huge datasets on PostGIS. For example building table includes more than 100k features in POLYGON geometry. When I want to get all data in QGIS (2.1) or other GIS software by using direct DB connection I wait about 30 sec. But if use WFS connection (GeoServer) it takes more time (don't try)... In a web GIS project (using OpenLayers) people don't want to wait in front of the screen. And I think OpenLayers can't handle with that amount of data... So I use to serve data by using WMS. It's really too fast and maybe later I try tilecaching etc... OK everything is so far so good. But I want to edit features (only insert maybe delete, but no update) in the browser.
I have checked OpenLayers examples for WFS-T. These examples load all data to by WFS. I don't want loading data just inserting new features by drawing and than clicking save button. So new features sending to GeoServer...
I tried with OpenLayers WFS-transaction example link. Firstly modified data map.addlayers([wfs,gpyh]);
to map.addlayers([gpyh]);
to load only googlemaps baselayer. There is no error during drawing but when saving I get error. I says
this.layer.map is null
var local = this.layer.map.getProjectionObject();
What do you advise me when working with big layers.Is my way correct. How can I handle with this issue? My JavaScript knowledge is limited.
EDIT
Some info about the system which I want to build:
I want to serve buildings, roads, boundary etc. layers to people. Not only showing but also editing capabilities it should have.
MY PROBLEM:
I don't want to load features to OpenLayers, I just want to draw new features and put them into database. And I use WMS for serving layers.
I use OpenLayers lib in client side (apprentice in JavaScript).
The data is stored in PostGIS., but I can use Spatialite.
GeoServer for WMS and WFS service.
I am not bad in Python and PHP. Maybe I can use FeatureServer. Also I can serve feature data with PHP or Python.