Does anyone have experience of extracting data via proxy table from Interbase.

SQLA version is 10.0.1.4310 IB is XE 10.0.2 474. IB is on one server, SQLA on another both pretty fast, network good. Can't change the architecture at this stage, Am using a 64-bit EasySoft IB ODBC driver installed on the SQLA machine (The IB provided ODBC driver wouldn't work). OS is 2008 Server R2 in both cases.

It connects (the Remote Server & Proxy Table definitions produced by the Sybase Central have to be tweaked) but the performance is dire - a few hundred (small) rows per minute is typical & I've got giga bytes of stuff to shift. A similar setup with MS SQL Server on same hardware was pretty instantaneous. IB performance on its own machine seems good.

I've tried the obvious settings in the ODBC driver - ReadOnly, Isolation Level's etc but makes no difference. It's not the inserts that are slow, writing out to disk from SQLA ISQL is just as slow.

I realise this is more an IB question, but wondered if anyone had any past experience with shifting from IB to SQLA.


UPDATE

Allocating more RAM to the IB cache & a re-boot seem to have helped a lot - quite why, I'm not clear but I'm not arguing :) Thanks everyone for your help and suggestions.

asked 23 Sep '14, 09:50

Justin%20Willey's gravatar image

Justin Willey
6.8k110142212
accept rate: 20%

edited 25 Sep '14, 11:37

BTW - I suffer from complete ignorance when it comes to configuring IB - so any suggestions welcome!

(23 Sep '14, 10:26) Justin Willey
2

Two suggestions: Set the cis_option option to 7 to see what SQL Anywhere sees, and turn on the ODBC trace to see what ODBC sees. Somewhere in resulting torrent may lurk a clue.

(23 Sep '14, 11:28) Breck Carter
Replies hidden

...and in case these valuable suggestions don't lead to a clue they will at least give a reason why the data exchange will be even slower...:)

(23 Sep '14, 11:40) Volker Barth

Thanks Breck - I'd forgotten about that option - I'll see what it shows.

(23 Sep '14, 11:40) Justin Willey
1

Do keep in mind that SQL Anywhere has even less knowledge about how IB works than you do so the trace should show very generic behavior. Also, any given ODBC driver implementations can very wildly, you may want to also use the IB equivalent of "request logging" to see what the CIS generated SQL gets transformed into. Good luck Justin. Let us know how that turns out.

(24 Sep '14, 10:17) Nick Elson S...
2

I have worked with EasySoft on performance related issues. My suggestion is to make sure you have the latest ODBC driver from EasySoft. Also, report the ODBC performance issue to them. They are a pretty responsive group. They'll also make sure you are running the latest driver.

(24 Sep '14, 10:29) JBSchueler
showing 4 of 6 show all flat view
Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×114
×63
×1

question asked: 23 Sep '14, 09:50

question was seen: 1,583 times

last updated: 25 Sep '14, 11:37