Sergio Castro's questions

I am trying to bulk insert data into Realm, but it is making it very slow.

this is my code:

            let realm = try! Realm()


            let group = GroupRealm()

            group.id = 1
            group.name = "test"

            try! realm.write { 
                realm.add(group)
            }

            var product = [String:AnyObject]()
            product["id"] = "" as AnyObject!
            product["code"] = ("") as AnyObject!
            product["detail"] = ("") as AnyObject!
            product["onHand"] = (0) as AnyObject!
            product["price"] = (0) as AnyObject!
            product["isSerialized"] = (0) as AnyObject!
            product["isLotNumber"] = (0) as AnyObject!

            var groupProduct = [String:AnyObject]()
            groupProduct["group"] = group as AnyObject!

            for r in 0..<300 {
                realm.beginWrite()
                for i in 0..<100 {
                    product["id"] = "\(i)-\(r)" as AnyObject!
                    realm.create(ProductRealm.self, value: product, update: true)

                    groupProduct["id"] = "\(i)-\(r)" as AnyObject!
                    groupProduct["product"] = product as AnyObject!
                    realm.create(GroupProductRealm.self, value: groupProduct, update: true)
                }
                try! realm.commitWrite()
            }

The objects I am using are these:

class ProductRealm: Object {
    public dynamic var id: String = ""
    public dynamic var code: String = ""
    public dynamic var detail: String = ""
    public dynamic var onHand: Int = 0
    public dynamic var price: Double = 0
    public dynamic var isSerialized: Int = 0
    public dynamic var isLotNumber: Int = 0
    override static func primaryKey() -> String? {
        return "id"
    }
}

class GroupProductRealm: Object {
    public dynamic var id = ""
    public dynamic var group: GroupRealm!
    public dynamic var product: ProductRealm!
    override static func primaryKey() -> String? {
        return "id"
    }
}
class GroupRealm: Object {
    public dynamic var id = 1
    public dynamic var name = ""
    public dynamic var update = Date()
    override static func primaryKey() -> String? {
        return "id"
    }
}

Testing on my iphone 5s to insert 30000 records takes over 30 seconds, while on an old project I have with sqlite it takes around 16 seconds.

I've read that realm is much faster at this than sqlite, so I know it's my mistake, but I can't find the D:

I am using a table view with a specific number of rows that allows me to switch to other project screens, however when I change to another storyboard the navigation controller does not allow me to return.

my code is the following:

override func tableView(_ tableView: UITableView, didSelectRowAt indexPath: IndexPath)
{
    switch indexPath.row {
        case 0:
            let storyboard = UIStoryboard(name: "Product", bundle: nil)
            let vc = storyboard.instantiateViewController(withIdentifier: "ProductViewController") as UIViewController
            present(vc, animated: true, completion: nil)
        break
        default: break
    }
}

This allows me to see the view controller of the other storyboard, I would like to be able to keep the navigation controller.

I managed to do this via the storyboard reference, although I couldn't assign the changes depending on the cell touched.

Any ideas?

I have in a SQLite database more than 10,000 records with products, and in a folder I have the images of said products, only I cannot load them all in one UiTableViewin Objective C.

I know that what I should do is load only the ones the user is going to see and a few more for when they scroll, but I can't find any example code for this, and my English is not that great.

For now I am only loading a limit of 1500 records in a NSArray, so that the device memory is not overloaded, but I need to be able to view all the products and that they load as I scroll (without loading times).

Does anyone know how to do this? What control do you have to use? Is the used for this?, or do I make queries every time the scrollNSCache moves , I'm not very clear on how to do it, I load the images from a project folder, so there's not much of a problem, I just tell the load from there, with the product reference.imageview