ThinkGeo.com    |     Blog    |     Wiki    |     Support

WorldStreetsLayerSample Performance Question

I am testing the WorldStreetsLayerSample solution, and I have a couple questions. I am using the included DallasCounty-3857-20170218.sqlite database.

  1. When I go to zoom in, it takes almost 4-7 seconds. Is this normal?
  2. When the program fist loads the DB and when I do zoom in, I get several of “SQLite error (1): no such table: main.sqlite_stat1” in the output window of Visual Studio. Is this normal?

Thanks,
Treasa

Hi Treasa,

Thanks for your question, the WorldStreetsLayerSample is an old project of “ThinkGeo World Streets”, it has been obsoleted, could you please try https://github.com/ThinkGeo/ThinkGeoMBTilesMapsSample-ForWpf instead, here all are rendered with a CSS similar map style file and did some performance improvements, it’s easy to modify the style. Besides, we will have a big release of the “World Streets” after one week, in this new release, we will release a complete new style of “World Streets”, a big performance imporved JavaScript library and .NET Core SDK (Winforms & WPF). If you want, please try https://maptest.thinkgeo.com, we are still doing some changes to it.

Here are the comments of the questions:

#1. Yes, it’s not normal. In the upcoming release, the map can be show up in 200 ms. If you would like a WPF or Winforms version to take a try, please let me know.

#2. I tried downloading the github sample https://github.com/ThinkGeo/WorldStreetsLayerSDKOnWindows-ForWinForms and build to run locally, seems like everything goes well, I checked the source code, seems like no code searches for the table “main.sqlite_stat1”, could you show me where the exception is thrown and wha’s the stack trace?

Thanks,
Johnny

Hi Johnny,

  1. Will you please send me the Winforms version to try? We are trying to use the SQLite DB with winforms in our application.

  2. It’s not an exception that is thrown - it is just a warning message that shows in the Output window when I load/zoom in on the map. I was wondering if that is why it is taking so long to render on my computer.

Thanks,
Treasa

Hi Treasa,

I apologize that I just confirmed with development team, the Winforms version is still in development, still need some time, but WPF version is available at https://ap.thinkgeo.com:5001/sharing/bdB5sc3sh, could you take a try?

For the performance of the GitHub sample https://github.com/ThinkGeo/WorldStreetsLayerSDKOnWindows-ForWinForms, I have show the performance issue to development team, they told me that they will dig into later, and any updates I will paste it here. Sorry for the inconvenience, if you still want the old Winforms version, please let me know, we may adjust the priority.

Thanks,
Johnny

Hi Johnny,

I downloaded the sample, but it says “Not Licensed for Run Time” on the Main Window screen, so I can’t see the database. Also, will this code also work with the a SQLite database?

Regarding the performance of the GitHub sample, if I put in a ticket, will someone be able to assist me quicker?

Thanks,
Treasa

Hi Treasa,

The sample is a demo to shows the better performance version we are working on, it work with SQLite, and based on our version 12, you can try to build a version 12 run-time license to view it. But it’s not release, so it cannot be introduced into your project now. Our website will release the news when it’s available.

Here is some suggestions to solve your issues:

  1. In current version load data and render data will takes some seconds, the best solution is open cache in LayerOverlay, you can set the FileBitmapTileCache on it, and when the second time map visit same tiles it will render very fast.

  2. This error is caused because the render logic don’t match your local database table structure, you can upgrade to the latest code and newest database. Because it’s opensource now, you can also modify the code to make it works. If you found it’s still hard to solve, please let us know more information about how to reproduce it, we can help you solve it.

I hope that’s helpful.

Regards,

Ethan

Hi Ethan,

Will you please provide me the link for the sample with the latest code and newest database? I want to make sure I am working from the correct version.

Thanks,
Treasa

Hi Treasa,

For reduce miss some information, I download the sample and run it correct today:

And then I build a zip file here:

https://ap.thinkgeo.com:5001/sharing/O4Q7t6azK (It will be available before 2020-05-30)

Please directly download it and unzip, then you need to do:
a. Unzip the DallasCounty-3857-20170218.zip in App_Data folder, the path should be WorldStreetsLayerSample\App_Data\DallasCounty-3857-20170218.sqlite
b. Restore the packages from Nuget, you don’t need update anyone, just restore is OK

Any question please feel free to let me know.

Regards,

Ethan