You are not logged in.

Connection takes about 40 seconds

Dear visitor, welcome to Palo Community Forum. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

h_decker

Sage

  • "h_decker" is male
  • "h_decker" started this thread

Posts: 763

Date of registration: Oct 26th 2005

Location: Cologne, Germany

  • Send private message

1

Monday, February 26th 2007, 5:56pm

Connection takes about 40 seconds

Hi,
I got an issue that connection to PALO-Server takes about 40 seconds. There isn't anything else I do, just connect and get the time. I use PALO Server 1.5 final and the java api 1.5 beta. Any ideas why it takes so long or should I wait for 1.5 final api?

Thanks in advance
Holger


CODE:

final long t0 = System.currentTimeMillis();

// connect to palo server on localhost with default credentials.
Connection connection = ConnectionFactory.getInstance().newConnection(
PALO_SERVER,
PALO_SERVICE,
PALO_USER,
PALO_PASS);
System.out.println( (float)(System.currentTimeMillis() - t0) / 1000.0f );

Michael

Master

Posts: 44

Date of registration: Feb 9th 2006

  • Send private message

2

Monday, February 26th 2007, 8:47pm

RE: Connection takes about 40 seconds

Hi,

how big is your database in terms of dimensions, number of elements, cubes?

Is it slower than Java Palo API 1.0?

Michael

h_decker

Sage

  • "h_decker" is male
  • "h_decker" started this thread

Posts: 763

Date of registration: Oct 26th 2005

Location: Cologne, Germany

  • Send private message

3

Tuesday, February 27th 2007, 8:32am

RE: Connection takes about 40 seconds

Hi Michael,
didn't test it with 1.0 API so far. I think I got the reason. One of the DBs is quite big: 13 Dimensions with up to 20.000 Elemems. Cube contains about 2,3 Mio populated cells. I think DBs are beeing scanned when getting the connection or so? When I delete the big DB and just leave the Demo-DB connection time is okay (about 1 or 2 seconds).

Holger
Rate this thread