3
Would this be a php limit? I upped the php limits:
max_execution_time = 120
max_input_time = 120
memory_limit = 16M
Restarted apache, nothing changed. The installations fails pronto, like it never even tries to do the inserts if there are more than about 1000 of them.
Reading the insert's into MySQL manually works fine.
Here is a sample:
CREATE TABLE gis_zip (
zip_id int(15) unsigned NOT NULL auto_increment,
zip_zip varchar(255) NOT NULL default '',
zip_x float NOT NULL default '0.0',
zip_y float NOT NULL default '0.0',
PRIMARY KEY (zip_id)
) TYPE=MyISAM;
INSERT INTO gis_zip VALUES (1,'95420',-123.78,39.36);
INSERT INTO gis_zip VALUES (2,'96703',-159.31,22.16);
INSERT INTO gis_zip VALUES (3,'96705',-159.55,21.90);
INSERT INTO gis_zip VALUES (4,'96714',-159.50,22.20);
INSERT INTO gis_zip VALUES (5,'96715',-159.34,21.99);
INSERT INTO gis_zip VALUES (6,'96716',-159.59,22.03);
INSERT INTO gis_zip VALUES (7,'96722',-159.51,22.15);
INSERT INTO gis_zip VALUES (8,'96741',-159.51,21.95);
INSERT INTO gis_zip VALUES (9,'96746',-159.36,22.11);
INSERT INTO gis_zip VALUES (10,'96747',-159.62,21.91);
INSERT INTO gis_zip VALUES (11,'96751',-159.31,22.06);
.
.
.
INSERT INTO gis_zip VALUES (41511,'04657',-67.37,45.01);
INSERT INTO gis_zip VALUES (41512,'04671',-67.16,45.06);
INSERT INTO gis_zip VALUES (41513,'04694',-67.46,45.09);
Doug P