NotesSQL with Delphi

HCL Domino Domino Forum
1

I use NotesSQL to get data from Notes into a Delphi application.

But i must wait a long time before the Delphi grids are filled with data from Notes. It can take seconds to minutes.

Is NotesSQL so slow? Is there a solution to make this work faster?

2

Subject: NotesSQL with Delphi

Did you read the documentation? In there tells ways of optimizing your database for the fastest queries.

Ron

3

Subject: NotesSQL with Delphi

The easiest thing is to use the Notes COM API.

It’s not that hard to use from Delphi.

You can download it from Notes.net in the tollkits and drivers section.

Andrew

4

Subject: NotesSQL with Delphi

NotesSQL is ODBC based so yes it is slow. It is relatively fast in small databases but it will take longer based on how you are connected. If you have a view with many columns and/or many records in a view that could impede on the response time.

There are solutions, but there are not as free as NotesSQL. [I use the notion you get want you pay for.] What I would suggest is to make sure the database is optimize for your Delphi needs.

There is api’s as well, but it will take some time to get use to how those work.

HTH Cheers

5

Subject: RE: NotesSQL with Delphi

Thanks for your reply!

Can you mention the solutions that are faster than NotesSQL?

And what is the best way to optimize the database for Delphi?

I looked to the method with API, but i couldn’t find the right information to get this working. Is there a place where there is information about that subject?

6

Subject: RE: NotesSQL with Delphi

Here are a few tips to get the most out of ODBC:

  1. Make sure you are not using a lot columns when you have lots of data. Like 10000s of notes documents.

  2. If the database is relatively small like under 20000 rows then you should be ok if you select a few columns (less than 5).

  3. What is you are retrieving back? Lots of text or a number/keyword? Text fields are really bad to use in ODBC – I try to limit the number of characters I would return back.

  4. Make more than one view for what you want to retrieve back (This is not good if you have a big database; i.e. 100000s documents) as in a view for account numbers to account names, one view for employee numbers to names.

Email me if you are still stuck… Email is in profile.

HTH Cheers