Re: query join 2 databases? or match up arrays?

well - the informix database will be running on another server (a telecom billing system). this is a web based front end, and I really want to leave the other system alone 100%. if I were to modify anything I would make the mysql permissions table inside of informix, but there are liability reason which would keep me from doing so. still - you bring up an interesting point. a php script file that ran on crontab may not be a bad answer. however, again I would run into a problem of volume. there are an average of 3-4 million card in the informix server so I couldn't do this in a export & import. too may records, and info has to be accurate within 15 minutes. shear volume I believe is going to kill that idea. I would be back to 1 record at a time running every 15 minutes. I would think too much load, and more practical to do it 1 record at a time upon request which won't be too frequent. hoping there's another solution I'm not aware of, or over looked. Jeff "Philip Hallstrom" <philip@adhesivemedia.com> wrote in message news:20030103154832.O93864-100000@cypress.adhesivemedia.com... > Any chance you can do a somewhat frequent export from informix into mysql > or the other way around so all your stuff is in one database? > > -philip > > On Fri, 3 Jan 2003, Jeff Bluemel wrote: > > > ok - here's my problem. I have some data in mysql, and other data in > > informix. > > > > here is my application. this is for distributors of prepaid phone cards. > > prepaid phone cards have 3 numbers they can be identified by pin number > > (which is unique), or by batch & serial number. the batch number is > > basically the type of card, and the serial number & batch number for another > > unique identifier when used together. > > > > now - a batch can be given to several different distributors. therefore, > > when then are pulling various types of information on the batch they should > > only be able to see it for their cards, and not all of the cards in the > > batch. > > > > piece of cake right? well - the permissions information is kept in mysql, > > and the batch information its self is kept in an informix database. there > > is no way around this for me. > > > > the only way I can think of to work around this problem is to query 1 card > > at a time, and sum the info etc. together. however, there could be 400,000+ > > records, and this would be a slow tedious process. plus for each card I'd > > have to query the mysql database for permissions, and then in turn query the > > informix database in turn. this could take a long time to display the > > webpage. > > > > clear as mud??? recommendations? > > > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > >