Once I start an import, there is no way to cancel it without force quitting servoy client. You can click next or continue, but the cancel button does nothing.
Bill Belanger
I guess you are talking about the import functionality from servoy client ? There was a bug related to cancel button not working that is fixed now.
Thanks, I’ll check for updates. I’ve played with uploading records. I can upload (import) 15 records. When I try a thousand, it locks up. I have to force quit the client. Is there some practical limit on what you can upload from a smart client? This is a plain, simple, no relation flat file to a table with no records and only about 10 fields.
Bill Belanger
There isn’t a limitation, just that for thousands of records may be slow. Even if you wait a couple of minutes doesn’t finish the import ?
I did the import into FIlemaker and it took 46 seconds. I tried again into the servoy database and today I noticed there is a progress indicator at the bottom of the screen. Didn’t notice it last night. It took 63 seconds to import the same records. The only difference was that the filemaker file already had 1200 records and there are indexes on some fields. I’ll do more testing on larger subsets. Still, that’s 25% slower. I would think with no indexes to update it should be faster.
I noticed that servoy application server does not restart after a server shutdown although it is set to startup type automatic. Also, I need to start developer to get the repository_server to start. How can I get that to start with the service?
Thanks
Bill Belanger
BillB:
I noticed that servoy application server does not restart after a server shutdown although it is set to startup type automatic. Also, I need to start developer to get the repository_server to start. How can I get that to start with the service?
Servoy server, unlike developer, doesn’t start the database automatically. So the reason that your application server doesn’t restart is probably because it can’t connect to the database.
How to create a service for the database depends on your database and your OS. If you use sybase on windows you have to install sybase central, after that open a console and use the following command:
<SYBASE_CENTRAL_DIR>\win32\dbsvc.exe -as -i -s Automatic -t Network -w <SERVICE_NAME> <SERVOY_DIR>\application_server\sybase_db\dbsrv10.exe <SERVOY_DIR>\application_server\database\<DATABASE_1>.db <SERVOY_DIR>\application_server\database\<DATABASE_2>.db
Replace the <…> values with what’s appropriate for you.
Bill, it will always be a bit slower than Filemaker, keep in mind that the Servoy client needs to send the data to the servoy server and the server needs to send queries to a SQL database while FM has a sort of “db like” integrated client side.
Search the forum and you will find a lot of posts about that, my personal hint is to use a specialized tool if you need to import a big amount of data.
Thanks Nicola. I only have to do this big import once, so I’ll just be patient!
Bill Belanger
Joas, I am running windows 2003 server. I downloaded sybase central. I don’t understand “console” I don’t see that as a menu item.
Bill Belanger
I just mean a windows console, go to “Start\Run”, type “cmd” and press “Enter”.