如何使用最快的方法250.000.000.000行数据创建

发布于 2025-02-14 00:50:14 字数 1425 浏览 2 评论 0原文

Helllo All，

我想在一个具有位置坐标的Azure CosmosDB项目上创建。昨天我在下面的API上创建了一种方法：

  [HttpGet("createzone")]

    public async Task<ActionResult<string>> CreateZones()

    {
        Container container = database.GetContainer(containerId);

        double x = 38.988599999993035;
        double y = 26.003399999999992;
        int id = 524962;
        while (y < 45.0000000001)
        {
            Console.WriteLine("x: " + x + " y: " + y);
            Zone newZone = new Zone
            {
                Id = "Zone." + id.ToString(),
                Title = "Zone" + id.ToString(),
                Owner = null,
                Coordinate = new Coordinate { Latitude = x, Longitude = y },
                PartitionKey = "id." + id.ToString()

            };
            await container.CreateItemAsync<Zone>(newZone, new PartitionKey(newZone.PartitionKey));

            x += 0.0002;
            id += 1;
            if (x>42)
            {
                y += 0.0002;
                x = 36;
            }
        }
        return "done";
    }

根据我的计算，如果数据继续如此

我neeed的内容，则将需要3年以上的数据： 创建应用程序中图上有正方形的区域，并确保所有这些区域都有唯一的数字。像这样：

我现在在应用程序中进行了同样的视觉效果。但是创建区域花费太多时间。

如何以最快的方式创建这些项目？

原文

Helllo all,

I wanted to create on azure cosmosdb items which one has location coordinates.
Yesterday i created a method on API below:

  [HttpGet("createzone")]

    public async Task<ActionResult<string>> CreateZones()

    {
        Container container = database.GetContainer(containerId);

        double x = 38.988599999993035;
        double y = 26.003399999999992;
        int id = 524962;
        while (y < 45.0000000001)
        {
            Console.WriteLine("x: " + x + " y: " + y);
            Zone newZone = new Zone
            {
                Id = "Zone." + id.ToString(),
                Title = "Zone" + id.ToString(),
                Owner = null,
                Coordinate = new Coordinate { Latitude = x, Longitude = y },
                PartitionKey = "id." + id.ToString()

            };
            await container.CreateItemAsync<Zone>(newZone, new PartitionKey(newZone.PartitionKey));

            x += 0.0002;
            id += 1;
            if (x>42)
            {
                y += 0.0002;
                x = 36;
            }
        }
        return "done";
    }

according to my calculations it will take more than 3 years for the data to be generated if it continues like this

What i neeed:
Creating areas shown with squares on the map in the application and ensuring that all of these areas have a unique number. Like this: