import limit?

[Guest]

Is there a limit to the number of rows that can be imported?
I did not succeed in importing 1,000.000 rows.

[Guest]

sorry forgot to log in.

Ron.

[maarten]

It's strongly recommemded to start using a database Tool with such amounts of records.

As a rule of thumb, don't let clients import export above 5000 records.
Inserting records from the clients side causes a lot of traffic.

(Can you give me an example why you would want a client to handle such heavy procedures?)

[Bert]

It's strongly recommemded to start using a database Tool with such amounts of records.

As a rule of thumb, don't let clients import export above 5000 records.
Inserting records from the clients side causes a lot of traffic.

This means that such amounts of records should be imported/exported on the server by a local administrator or if possible with a remote tool if there's one available for the platform the server is running on because the server can be anywhere on the globe.
In the last case one should consider wich platform de server should run on when looking at platformdependant import/export tools.

I know there was a topic about these import/export tools last but would it be possible to have such a feature build in Servoy Server one day

Thanks...

[maarten]

We would have to build a seperate database tool for each database :
And that's gonna take loads and loads of time!

It certainly would be nice to have this integrated in Servoy,
but for now it would take on to many recources.

[Jan Aleman]

There will be some interesting possibilities in servoy 2.0 final. We'll discuss them when they appear.

[DFehrenbach]

To revist this topic:
I am preparing to implement a Servoy solution re-designed from an existing FM solution. There are many tables with upwards of 80,000 records each. I started, and presently have the Servoy solution in Firebird. Earlier when I tried to import test data into the Firebird Database I ran into painfully slow run times both with Servoy and with IB Firebird Manager tool.
My questions are:
Does anyone have any knowledge of the relative benefits of Firebird or Servoy with respect to loading files from text files?
Is it difficult to port the solution to Sybase from Firebird? If not, what are the steps to do so?
Thanks.

[Jan Aleman]

Sybase offers fast import tools to get your data imported.
You can move your solution by exporting it (using the repository dialog), repoint your named connection (the one the solution used) to ASA and then import the solution again. If you tell it to export sample data it will export up to 10,000 rows of your data with the solution that you can the transfer to the new solution as well.