data (#23) - time of finding path (#389) - Message List

I have the same problem, I think, and also try to solve it. It seems like there is bottleneck in selection from ways table. I reduced total amount of ways in Europe and Russia to 4.2m using only ways of needed classes. Also I select only ways from area between points

$delta = 1;
$minLon = min($cityFrom['longitude'], $cityTo['longitude']);
$maxLon = max($cityFrom['longitude'], $cityTo['longitude']);
$minLat = min($cityFrom['latitude'], $cityTo['latitude']);
$maxLat = max($cityFrom['latitude'], $cityTo['latitude']);
$res = $conn->execute("
      SELECT
        *
      FROM
        shortest_path(
          'SELECT
            gid AS id,
            source::int4,
            target::int4,
            length::double precision AS cost
          FROM
            ways
          WHERE
              x1 > ".($minLon - $delta)." AND x1 < ".($maxLon + $delta)."
              AND
              x2 > ".($minLon - $delta)." AND x2 < ".($maxLon + $delta)."
              AND
              y1 > ".($minLat - $delta)." AND y1 < ".($maxLat + $delta)."
              AND
              y2 > ".($minLat - $delta)." AND y2 < ".($maxLat + $delta)."
          ',
          ?,
          ?,
          false,
          false
      ), array(
        $cityFrom['edge']['source'],
        $cityTo['edge']['target'],
));

But it seems still not enough to find path between e.g. Moscow and Madrid in sufficient time, it takes now about minute. "SELECT .. FROM ways" still selects 2.4m of rows and takes all RAM that way.

Maybe it is more related to PostgreSQL optimization than PgRouting?, but are there ways to improve speed?

Thank you. What do you mean by clever strategy load data? Site  http://maps.map.cloudmade.com search path takes a few seconds. How is this done?