SQL Anywhere version 12.0.1.3797
I have a performance problem with one of the databases. The query has about 30 "left outer joins" to stored procedures. For this report about 10 tables are involved with about 2.000.000 rows per table.
Database i...
We have created a .Net assembly with Powerbuilder 12.5.1 build 4541.This .NET assembly is used in a c# program.When we try to save data to a SQL anywhere database using a datastore we get error.System.AccessViolationException was unhandled
HResult=...
SQL Anywhere 12.0.1.3797We use the "Synchronize profile" statement to upload data to our consolidated database. On one computer we have a problem, the upload is not starting. When we use the program dbmlsync.exe there is no problem. When we copy the ...
An external program is dumping .xml files in a folder.As soon as the file is dumped we should import it in our SQL anywhere 12 database and move this file to a other folder.We do not know the names of the external files but the extension is allways ....
A part of a function in our database looks like this:while @datecount <= today() loop set @datecount = dateadd(day, 1, @datecount); insert into gt_datetable( countdate ) values ( @datecount );end loop; We have to insert about 200000 records in ...
Thanks Breck,Still some problems. I triedCREATE VARIABLE x XML;SELECT xp_read_file( 'c:\\klad\\22192MOT4772.xml' ) INTO x;SELECT * FROM openxml( x, '//*' ) WITH ( attributename CHAR(128) '@name', text LONG VARCHAR 'text()' );This returns the i...
Thanks Breck,Performance suddenly decreased. About 2 records per second are processed. Apply upload: 6.676,578 Upload bytes: 395069 Upload insert rows: 8218 Upload updated rows: 643Today the message below appeared in the Mobilink console. Possibly ...
