Well.

[outlier_lynn]

I spent two hours trying to figure out why when I imported the names of 6,500 pictures into the database, it consistently stopped at 468 (or something like that). Frustrating at hell. I could do the inserts without a problem at an SQL command line, but my scriipt routinely made only 468 inserts.

Finally, while telling Aeire what was up, it dawned in me. I'm using one of MY routines for doing the insert. And the one I was using would not allow duplicate entries. Filling one column of a table with a picture name (set by the camera when the picture was taken) was showing "dulicates" all over the place. :) There are 468 unique names in all of the galleries. :)

Well, all is done (at least for the public access parts and for the admin editing parts. I do have to finish the gallery installation part, but that is trivial at this point.

It's a little slow, though. Enough to be a bit annoying. I think it will all get rebuilt with some of the common procedures installed in the database itself. I'm making way too many separate calls to the database.

I have all week to play with it. I'll not put the new stuff on line until I have a new gallery to create (next weekend). Maybe I'll be able to speed the puppy up quite a bit.

Now, I'm off to look for fishnets with a built-in garter belt.

Comments

[blueelephant.livejournal.com]

I recomend stored routines in the database.