URGENT Question...

[Jokez]

Hi!

We have an SQL database and wants to use XSLT to add data from that database into Filemaker, but it goes deadly slow. Is there anything you should think of using XSLT? Or is there a faster technique to use?

// Joakim Sjöberg, Johnér Picture Agency

[Genx]

Use ODBC?

[Jokez]

Hmm everyware we have read about odbc it sais that it´s slower than xslt? What is the case with FM? Is there anygood examples of xslt imports anyware?

thnx for all the help! Its most appriciated!

// Jocke

[Mikhail Edoshin]

What kind of SQL database it is? How exactly do you use XSLT to get the data from it?

[Genx]

Hmm everyware we have read about odbc it sais that it´s slower than xslt? What is the case with FM? Is there anygood examples of xslt imports anyware?

Fine... use Fx.php or the FM PHP API, both just classes for php to interact with FM's XSLT..

[Jokez]

We use SQL to get data out of our PostgreSQL database, that is not the problem, but then we construct XSLT files to insert the data into FM and that goes soooo slow...

[Mikhail Edoshin]

Transforming XML using XSLT can be slow if the file has many records. That is the format is intended to represent complex non-normalized documents, e.g. an invoice with full information about the seller and buyer, all the lines, some information about products, etc. It's not designed to perform number-crunching tasks, like an import of thousands of records. So the first question is: how many records you are trying to import?

If the number of records is large, like maybe more than 100,000 records, then I'd try to export into some format that is designed to hold table-like data, e.g. tab- or comma-separated text file.

If the number of records doesn't seem large, please post a sample of the XML file and the XSLT file you use. Or send an email to m.edoshin (th@t-little-symbol) mac.com.

[Jokez]

Thnx! I have sent you a mail!

Best regards Jocke