You are here:  » Complex search and ultra large database

Support Forum



Complex search and ultra large database

Submitted by babrees on Sun, 2011-04-17 05:53 in

Hi David

Further to my post last night...

Well, I set the slow import for one database yesterday, but it was still importing this morning!!! It was up to well over 3 million! I knew it would be big but didn't realise THAT big! I thought that is just too big so I cancelled the import.

I thought about the possibility of restricting the importing to just so many, and if my WordPress post can't find the item in the database have it come up with a link to the merchant (only dealing with 1 merchant). Ideally that link would be a search on the merchant's site for it, but as it is holidays the merchant doesn't just have a simple search for, say, a name of a hotel.

Not quite sure how to get on with this one now, please ignore my previous post, unless of course you work your magic, have come across this before and have a solution .

Cheers!
Jill

Submitted by support on Mon, 2011-04-18 08:10

Hi Jill,

You can fix an import limit in includes/import.php by replacing the default limit of "0" if no other limit is specified - at line 32 you will find:

    $limit = 0;

...simply REPLACE that with:

    $limit = 100000;

(or whatever limit required).

Alternatively of course it can be entered in the command line, e.g.

import.php @ALL 100000

Cheers,
David.
--
PriceTapestry.com