Hi all!
I need to perform quick search on dbf, i.e. find specific record by some
attribute. I am thinking about using ODBC via JDBC, because
1) it can be used like this:
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc:odbc:Driver={Microsoft dBase Driver (*.dbf)};DBQ=d:/shapefiles";
Connection con = DriverManager.getConnection(url);
Statement st = con.createStatement();
ResultSet rs = st.executeQuery("SELECT * FROM countries where
name='Homeland' ");
st.executeUpdate("CREATE TABLE NEWTABLE (NAME CHAR(32), PASSWD CHAR(32))");
con.close();
2) I don`t know, by I believe it can create index on specific field, so
search will be about log2(n) time (n is recordCount).
3) Default geotools data access is slow, unfortunately. Besides, it
cannot use attribute index on dbf, as far as I know.
So, the question: Does anybody ever performed fast searches on DBFs?
What did you used, if so?
If ODBC is a good choice? In future we will port our app to unixes, will
we have dbf odbc there?
Thanks,
Sergey
------------------------------------------------------------------------------
Start uncovering the many advantages of virtual appliances
and start using them to simplify application deployment and
accelerate your shift to cloud computing.
http://p.sf.net/sfu/novell-sfdev2dev
_______________________________________________
Geotools-gt2-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
