Hey! I’ve successfully connected a database to create virtual pages (there’s many database entries and it makes sense to do this as a database instead of real content pages) but I’m unsure how to handle images.
It seems that when uploading an image a new folder gets created but no direct link to the uploaded image is provided, instead having a field save to the database saves a vague reference. How would I be able to integrate images because as it stands now the database connection doesn’t really serve much purpose speed-wise if it doesn’t work well with images.
Thanks for the answer! I’m a little confused however what you mean by this. We need a Kirby site that has some normal page but also has an archive that has about 2,000 pages. Wouldn’t making those 2,000 pages virtual pages and a database connection speed-up things?
The problem is that with the children() method you load all database entries into memory at once. So a flat structure with only one parent can result in a bottleneck, and a tree-like structure would be better suited.
2000 articles could still be fast enough (at least worth a test), but will depend on the resources on your server, so I’d probably not do this on cheap shared hosting.