Chris, I cut my Witango ( Tango 3x ) teeth on FMP and Mac. It was a painful process with lots of work around's to deal with FMP.
Since then I have worked with SQL as the backend and while I am still earning all that the SQL engine can do I no longer fear loops or searches or complex searches. I am not real familiar with MySQL but more with SQL 2000. When I have to run a complex search, update or insert I usually test it in the Query analyzer 1st and it gives me an idea of how long it will take and if there is anything I can do with the tables themselves to speed the process. I may be wrong but to the best of my knowledge WiTango opens a connection to the DB once and keeps it open for the duration of the action. So the loop does not create a new connection for every insert. I often have found that with debug on it takes longer to write out the debug with all the multiple loops than it does to do the action. Much longer. So if you are trying to get an idea of the time it takes in an action with a lots of loops I would set the loop counter for a small number 1st just to make sure my loop works right. Then turn debug off and run it. The difference in any SQL DB vs. FMP is astounding when you are pounding on it with Witango so I found it was best to forget almost everything I learned about those two and open my mind to the new possibilities. Dan -- Dan Stein Digital Software Solutions 799 Evergreen Circle Telford PA 18969 Land: 215-799-0192 Mobile: 610-256-2843 Fax 413-410-9682 FMP, WiTango, EDI,SQL 2000 [EMAIL PROTECTED] www.dss-db.com > From: Chris Millet <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > Date: Wed, 18 Dec 2002 11:33:30 -0600 > To: Multiple recipients of list witango-talk <[EMAIL PROTECTED]> > Subject: Re: Witango-Talk: Inserting multiple records > > Thanks for your prompt replies. This is what I needed to know. > > Actually, a loop works quite well using SQL -- I was a little gun-shy from > using FileMaker for so long. I'm also discovering how much more powerful and > flexible SQL is and thought there might be an alternative I didn't know > about. > > Chris > > >> I agree. A loop is the easiest way to do it, but Chris did ask for >> alternatives. >> We once built a system that had to import 10s of thousands of records, >> obviously too much for an insert loop. We did it with shell scripts and it >> worked fine. >> >> -----Original Message----- >> From: [EMAIL PROTECTED] >> [mailto:[EMAIL PROTECTED]]On Behalf Of Dan Stein >> Sent: Wednesday, December 18, 2002 11:33 AM >> To: Multiple recipients of list witango-talk >> Subject: Re: Witango-Talk: Inserting multiple records >> >> I've always found the loop to be pretty fast even with 100's of records. >> -- >> Dan Stein >> Digital Software Solutions >> 799 Evergreen Circle >> Telford PA 18969 >> Land: 215-799-0192 >> Mobile: 610-256-2843 >> Fax 413-410-9682 >> FMP, WiTango, EDI,SQL 2000 >> [EMAIL PROTECTED] >> www.dss-db.com >> >>> From: "David Shelley" <[EMAIL PROTECTED]> >>> Reply-To: [EMAIL PROTECTED] >>> Date: Wed, 18 Dec 2002 11:21:50 -0500 >>> To: Multiple recipients of list witango-talk <[EMAIL PROTECTED]> >>> Subject: RE: Witango-Talk: Inserting multiple records >>> >>> Chris, >>> >>> You can't directly insert an array into a db table. >>> You may be able to write the array out to a file and use a database IMPORT >>> command to load it into a table. I doubt that the ODBC driver supports an >>> IMPORT command but you might be able to call it from a stored procedure, >>> external action or shell script. However the overhead of doing this may be >>> such that it would be faster to loop through the array and do INSERTs, >>> unless the array is very large. >>> >>> Oh wait, you said 'an easy way'. OK never mind. >>> >>> Dave Shelley >>> >>> -----Original Message----- >>> From: [EMAIL PROTECTED] >>> [mailto:[EMAIL PROTECTED]]On Behalf Of Chris Millet >>> Sent: Wednesday, December 18, 2002 10:42 AM >>> To: Multiple recipients of list witango-talk >>> Subject: Witango-Talk: Inserting multiple records >>> >>> >>> Is there an easy way to insert multiple records into a database without >>> using a loop? It seems DirectDBMS would work since MySQL will insert many >>> rows at a one time from other tables and files using the INSERT...SELECT >>> statement, but I'm not certain how it would work using an array. >>> >>> Chris >> >> ________________________________________________________________________ >> TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] >> with unsubscribe witango-talk in the message body > > ________________________________________________________________________ > TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body > ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
