
	Home > Ask the Domino Experts > Web Development and Downloads Questions & Answers > LotusScript data retrieval too slow

Ask The Domino Expert: Questions & Answers

EMAIL THIS

LotusScript data retrieval too slow

EXPERT RESPONSE FROM: Jens Bruntt

		Pose a Question

		Other Domino Categories

		Meet all Domino Experts
		Become an Expert for this site

Digg This!

StumbleUpon

Del.icio.us

QUESTION POSED ON: 25 March 2002
We have written LotusScript to retrieve data from another system. Both LEI and ODBC connection have been tested. The result is very unsatisfactory. It took us 90 seconds for LEI or 180 seconds for ODBC to retrieve 1 record from a 100,000-record file. We have also tried the same SQL command using MS Access to connect to that ODBC connection. It took us only 1 second. Are there any specific areas for Notes configuration or LotusScript usage for us to review? Kindly advise.

Your situation sounds odd to me. There isn?t really any place for configuring something that influences the performance of your LotusScript. I think that there is some bottleneck here that has nothing to do with Domino or Lotus Notes. Did your MS Access example run from the same server as did your LEI or ODBC connection? I think not. Try installing MS Access on the same server, and do the test from there. I certainly hope that you will find that Access has the same, bad, response times then. To me, it sounds like you have a LAN problem or maybe your Domino server is unable to handle its current workload. Memory, disks, CPU ? something could be too old, too slow, too little or just plain broken.

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	Web Development and Downloads
	Programmatically copy and hide attachments in Lotus Notes rich-text fields
	Programmatically edit a rich-text field table from within the Lotus Notes client
	Troubleshooting Lotus Notes Domino tabbed table problems
	Verify Lotus Notes user access to Web pages
	Can LotusScript agent display search results using specific view?
	Creating Word doc from form works in Notes 5.0.2 but not 5.0.11
	XML vs. JavaScript to fill in dropdown on form
	Debugging Web agents
	Configure an IM hot spot on Web page
	Can I use PHP to change tables in MySQL DB running off Domino?

RELATED RESOURCES

2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems

Search Bitpipe.com for the latest white papers and business webcasts

Whatis.com, the online computer dictionary

Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.

Browse our Expert Advice
Operating Systems IT Management Networking Database	Security Servers and Storage Applications and Development Career Center

Lotus Notes Domino on Blackberry and mobile devices

SEARCH

TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.


TechTarget Corporate Web Site \| Media Kits \| Site Map All Rights Reserved, Copyright 1999 - 2009, TechTarget \| Read our Privacy Policy