Jokez Posted May 29, 2007 Share Posted May 29, 2007 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 Link to comment Share on other sites More sharing options...
Genx Posted May 29, 2007 Share Posted May 29, 2007 Use ODBC? Link to comment Share on other sites More sharing options...
Jokez Posted May 29, 2007 Author Share Posted May 29, 2007 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 Link to comment Share on other sites More sharing options...
Mikhail Edoshin Posted May 30, 2007 Share Posted May 30, 2007 What kind of SQL database it is? How exactly do you use XSLT to get the data from it? Link to comment Share on other sites More sharing options...
Genx Posted May 30, 2007 Share Posted May 30, 2007 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.. Link to comment Share on other sites More sharing options...
Jokez Posted May 30, 2007 Author Share Posted May 30, 2007 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... Link to comment Share on other sites More sharing options...
Mikhail Edoshin Posted May 30, 2007 Share Posted May 30, 2007 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. Link to comment Share on other sites More sharing options...
Jokez Posted May 30, 2007 Author Share Posted May 30, 2007 Thnx! I have sent you a mail! Best regards Jocke Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6193 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now