Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Re: [Alex] Multiple database usage in same Links SQL? - Suggestion

Quote Reply
Re: [Alex] Multiple database usage in same Links SQL? - Suggestion In reply to
I just want to bring this topic up again because I'm still highly interested in a multiple database solution, too.

What I need is not having all LSQL-tables in every database.
I want to use multiple databases to store multiple LSQL-Link tables.

Coming to the point:

I'm importing lots of product datafeeds of different online-shops into my LSQL-db.

I want to have a Links-Database for each shop but all the rest in the main db.
While building the directory all data should be merged into one single directory
(all Links-tables should have the same structure).

I need this in reason of speeding up the directory and reducing the size of the links-table(s).
Actually I am limited in importing all datafeeds because of the reasons mentioned above.

If I would import all my datafeeds, my actual links-table would have more than 10 million rows.
So I think it's clear to everyone, that dealing with multiple db's with just 150.000 to 500.000 rows (a db for each datafeed) would be much better.

Regards,
Manu

Shopping Portal Shop-Netz.de® | Partnerprogramme | Flugreisen & Billigflüge | KESTERMEDIA e.K. | European Affiliate Marketing Forum.

Last edited by:

ManuGermany: Dec 1, 2005, 12:36 AM
Subject Author Views Date
Thread Multiple database usage in same Links SQL? - Suggestion webmaster33 6928 Feb 4, 2002, 8:35 PM
Post Re: [webmaster33] Multiple database usage in same Links SQL? - Suggestion
webmaster33 6730 Feb 6, 2002, 11:55 AM
Thread Re: [webmaster33] Multiple database usage in same Links SQL? - Suggestion
webmaster33 6768 Feb 8, 2002, 10:28 AM
Thread Re: [webmaster33] Multiple database usage in same Links SQL? - Suggestion
BeaverheadRiver 6820 Feb 8, 2002, 11:45 AM
Post Re: [vanderen] Multiple database usage in same Links SQL? - Suggestion
webmaster33 6718 Feb 9, 2002, 10:14 AM
Thread Re: [webmaster33] Multiple database usage in same Links SQL? - Suggestion
Alex 6959 Feb 9, 2002, 3:22 PM
Thread Re: [Alex] Multiple database usage in same Links SQL? - Suggestion
webmaster33 6795 Feb 10, 2002, 6:38 AM
Thread Re: [webmaster33] Multiple database usage in same Links SQL? - Suggestion
Alex 6667 Feb 11, 2002, 10:59 AM
Thread Re: [Alex] Multiple database usage in same Links SQL? - Suggestion
webmaster33 6708 Feb 11, 2002, 11:24 AM
Thread Re: [webmaster33] Multiple database usage in same Links SQL? - Suggestion
Alex 6712 Feb 11, 2002, 11:29 AM
Post Re: [Alex] Multiple database usage in same Links SQL? - Suggestion
rgbworld 6371 Apr 13, 2005, 5:07 PM
Thread Re: [Alex] Multiple database usage in same Links SQL? - Suggestion
ManuGermany 6293 Dec 1, 2005, 12:34 AM
Post Re: [ManuGermany] Multiple database usage in same Links SQL? - Suggestion
webmaster33 6235 Dec 3, 2005, 7:00 PM
Post Re: [ManuGermany] Multiple database usage in same Links SQL? - Suggestion
webmaster33 6223 Jan 16, 2006, 7:51 PM