I have a database (NexusDB (supposedly SQL-92 compliant)) which contains and Item table, a Category table, and a many-to-many ItemCategory table, which is just a pair of keys. As you might expect, Items are assigned to multiple categories. I am wanting to all the end user to select all items which are ItemID | CategoryID -----------...
I am trying to get info from an embedded db called NexusDB using java. Alternative 1: I've read in NexusDB website that there is an ODBC driver so I might use it with unixODBC. Then I need to do a JDBC-ODBC Bridge as stated here. Alternative 2: Get some sort of application to migrate NexusDB db to another db. Would like to know one. ...
I know that there are many Delphi database related questions available, but I'm considering only these two databases. I will need to query around 100.000 records. From your experience which one is faster: as embedded as C/S Thanks. ...