I have just tried importing a large merge file into a new ASA SQL table. It’s only 2 text fields and 2 int fields, with 250,000 records. The db is on the same machine, and this is the only table in the db. There are no relationships.
It took 4 hours. (it took less than 2 minutes to export the merge file from FM). Is this expected performance?
Servoy Developer 2.2.4
Mac OS 10.4
Java 1.4.2-54
nothing else running.
Use Sybase Central for import of large record sets.
Thanks Westy. Will give it a go.
There’s not a lot of info in the docs (that I’ve found) on indexing. It’s a little disappointing that indexes can’t be created from within Servoy (I like the index as required feature of FM).
Any tips on good index practice? Do we need an index for every relationship - and what about multi key relations?
Indexes are extremely easy to create with Sybase Central. Using Windows you just double-click the table name and then select the ‘Index’ tab. Then right-click and select ‘New/Index’ to pull up the Index Wizard. I do not use a Mac, but assume the procedure is similar.
My experience has been that indexes are usually not necessary. However, I do use them for large record sets on columns that will be searched.
See the following link for more information:
The LOAD TABLE SQL statement supports ASCII file formats and is the fastest way to import data. Check out the online help for this statement.