Home > Default > How to query large affiliate iphone app large database?

How to query large affiliate iphone app large database?

November 30Hits:0
Advertisement
We are building a website similar to http://appshopper.com/.
We imported successfully EPF files into relational mysql database using a tool from apple site http://www.apple.com/itunes/affiliates/resources/documentation/epfimporter.html
We got a serious problem which make us not able to continue our project. When we combine application table and application_price table to look for apps matching a specific description, but this query statement takes around 10s to be completed. 10s is so long and not acceptable for the kind of website. We have tried our best to speed up the process for 1 month, but we are still not able to find out a solution for the issue.
Could anyone from apple or who is experienced with issue give some help?
I really appreciate your help.

Answers

<BLOCKQUOTE><font size="1" face="Verdana, Arial">quote:</font><HR>Originally posted by Geegee:
Could anyone tell me the steps to Insert large xml file into a database table..<HR></BLOCKQUOTE>
IMO you has to write a ContentHandler for a SAX parser. Solutions based on DOM technique requires to load the entire XML file to the memory.
Best Regards, Marcelo.
null

Read other 3 answers

Tags:

Related Articles

  • How to query large affiliate iphone app large database?November 30

    We are building a website similar to http://appshopper.com/. We imported successfully EPF files into relational mysql database using a tool from apple site http://www.apple.com/itunes/affiliates/resources/documentation/epfimporter.html We got a serio

  • Querying large XML files with WEBSERVICE()November 30

    I am trying to use the function WEBSERVICE to query large chucks of data, without success Let's go with an example : =SERVICEWEB(http://api.eve-central.com/api/marketstat?&regionlimit=10000002&typeid=2305")) This line works, and give me the f

  • Can we query through 5-6gb large database with AIRNovember 30

    As it creates one single file for whole database, can we have 5-6 GB large database if an AIR application requiresThere's no arbitrary limit to the database size. It would depend on performance and the user's file system, I suspect. Only you could ju

  • Trouble adding printer to HP ePrint Home and Biz iPhone app - can't find printer's email addressOctober 11

    I'm trying to connect my HP Photosmart c6380 to my iPhone. I already downloaded the app and my printer is connected to my wireless network, as is my iPhone, but I can't add my printer to the app. When I go to "Manage ePrinters" and try to add a

  • I want to run Iphone apps on my Macbook Pro. Is this possible?October 11

    I like some apps very much and would just like to access them on my computer so the screen is larger.  Maybe there is an app for this.  I tether my Mac via USB so my phone ( Iphone 4 ) is hooked up when I'm using my computer.This isn't really possibl

  • Adding search to Dashcode (converted to a native iPhone app using webview)November 30

    I'm developing an iPhone app using Dashcode and would like to add Search capabilities (e.g search through all the content in this app). Does anyone know how to add this using Dashcode? I'm converting the app to a native iPhone app using webview in Xc

  • HT202159 How to I get to iPhone app support on my mac?November 30

    I am having a problem with interrupted iPhone apps, but it is so much easier to type an READ on a larger screen. How can I get to the iPhone app support from my mac? -bcNo. When i went back from this screen I followed a link and filed an apple suppor

  • Will iphone apps work on ipadNovember 30

    will iphone apps work on ipadApart from a few that require, for example, full phone capability yes (and as long as you have the appropriate iOS version installed on your iPad). If the apps are universal apps (indicated by a '+' symbol against them in

  • Need an experienced coder to write iPhone app locally-KCNovember 30

    I am looking for an experienced coder to write an iPhone app. here in K.C. MO. I am starting to think that they don't exist. Extremely hard to find. Are most of you developers in business for yourself or working for a company? Just wondering. And you

  • How to update iphone apps over 100mbNovember 30

    how do I update iphone apps over 100mb in itunes?Meg's answer is, as always, correct. I am confused by the "in iTunes" portion of your question. Are you asking how to download large apps using iTunes on your computer?  Or is "in iTunes"

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.764 s.