accessing as400 data from a web server

[abacuscorp]

I have a client whose website has to access an inventory file on the AS/400. Whe web programmer is using MS-SQL along with Client Access to accomplish this. It is working now in test mode. I'm somewhat concerned about response time down the road even though this will probably not be a highly used site. He is accessing garments in the file based on their style and size. In reality the UPC code is the real piece of data that should be used. I've built a logical using UPC over the file but he is still going after the physical file. Do you not think that going after the logical, rather than the physical, would be faster? If you have any experience in this area I'd really like some comments. Thank You.

Warren

 

[iSeriesCodePoet]

If they are using SQL (if they are doing ODBC they are) then the AS400 will automatically choose the correct logical if there is one. If you want to tweak that, use my faq317-3546, you can optimize the SQL statement so you can garentee the optimial speed. I hope this helps. Let me know if you want more detail on how this works. Or you can read the DB2 manuals on the IBM site.

iSeriesCodePoet
iSeries Programmer/Lawson Software Administrator

http://www.koldark.net

See my progress to converting to linux.

http://linux.koldark.net

 

[onpnt]

I think hitting the PF with the appliaction on the web will be more efficient but testing both will yeild the true results. reasoning I would think the PF will be parsed better is the 400 has little to no intervention at that point but to simply be the data source while the web app does the work. like I said though this question is really answered by tests on the file types via the web app. I've done many of these and that has always been the factor in choosing the more eficient manner of hitting the box. depending on how you're creating the applications and what the server is there should be little changes needed to adjust for these tests. possible only a line or two in your connections along witht he SQL statements.

_____________________________________________________________________

_{Hakuna matata!!}

 

[iSeriesCodePoet]

Actually, from whatever I have heard. It doesn't matter if you are hitting the logical or if you are hitting the physical file. DB2 will always create it's own access path if the logical isn't the most optimized one. Testing will always show you the real results, of course.

iSeriesCodePoet
iSeries Programmer/Lawson Software Administrator

http://www.koldark.net

See my progress to converting to linux.

http://linux.koldark.net