Advertise here




Advertise here

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In with Google Sign In with OpenID
Please do not post the same thing multiple times. The board software automatically flags certain posts as needing moderator attention. This happens the most often for new users. I'm pretty sure this is made clear at the time you attempt to post. Posting the same thing over and over again just makes that many more posts the moderators have to weed through later. This makes us sad. Don't make us sad. If your post/thread doesn't appear, just wait a while. Don't post it again. If it hasn't shown up by the next day, then you can try again. I normally go through posts in the mornings, and try to check a few times throughout the day, but I'm not here 24/7. There will typically be a significant delay before posts are approved. Just be patient.

Optimal Implementation for Large DB?

I am a beginning coder seeking some confirmation that I am spending my time well on my first major iOS project.

My app idea is based on hosting a large database (100,000s of rows, multiple GBs of space), indexing it and building an iOS app to fetch specific records based on a user selected pre-structured query. I do hope to make it pretty but functional is my first goal...

The database will be updated manually and rarely, usually about 4 times a year. It does not need to be updated by any sort of connection to the iOS app. It seems obvious to me that, due to the size of my DB, Core Data's memory based structure is not the best solution. To date, my reading and study seems to suggest that a hosted MySQL database accessed by the iOS app through a PHP web app is the way to go. Is that true?

Before I spend every second of my spare time the next few weeks diving into PHP I thought I would seek counsel as to the wisdom of that solution. As am very new to almost all coding, please feel free to treat me as a complete idiot assuming I know nothing... I've scoured the interwebs and read extensively, but nothing can replace good old fashioned advice...
Sign In or Register to comment.