Originally posted by: Nerav

I am working on Site selection problem from Brake to DC. It has two dimensional array.

tuple Distance //Defining tuple for distance
{
key string brake;
key string dc;
float distance;
}

{Distance}distance=...;
float Dist[distance] = [d: d.distance| d in distance];

When I run the model with data in .dat file it runs perfectly fine in 23 sec.But when I connect it to SQL database it takes forever. Any advise is appreciated

PMedianModel_DemandbyDC.dat has the syntax for connecting it to database

Hi

have you tried to change the batch size as explained at

http://www-01.ibm.com/support/docview.wss?uid=swg21665745

?

regards