First question:
Why are you creating two caches?
I would expect this to double the loading time
(Though given that poolTable_load1 doesn't
seem to be defined anywhere, I can't see
how this code would even compile!)
->>oooppppsss....that was a silly try.... forgot to comment 2nd cache
totally...(after removing it, Code runs as I told you in earlier mail)
before mailing you
Second:
If the problem is the time taken to load the data,
it's perhaps worth doing some profiling on the code
used for this, to see where the bottlenecks are.
For example, is it actually necessary to dynamically
allocate memory within the 'getfield' routine?
This is then parsed as a decimal number, and
then released immediately.
->> yes as the original CSV file is very dynamically change its data ,I
suppose to use this method.
And actually I found this is the best method to read CSV(dynamically)
How about if you did the 'strtol' parsing within the
'getfield' routine, and returned a pointer to a (static)
structure that contained the three values.
Or perhaps use 'sscanf' to combine the tokenisation
and parsing steps.
Either or both of those might or might not be faster,
but it's worth doing some simple timing tests to find out.
If that's still not fast enough, perhaps you could convert
the data file to a binary format, which should be much
faster to load.
--> Ya I have tried this.... without snmp the normal code is running enough
fastly.
Or allocate a single fixed array for the whole table,
rather than calling 'netsnmp_tdata_create_row()'
to allocate memory for each row individually.
--> that I would try...
If the index values are guaranteed to be sequential,
you might even wish to avoid the linked-list approach
of the table_tdata helper altogether, and craft your
own handler that went straight for the appropriate row.
Which should be faster still.
--> actually no index number is not in a seq. In real It is a unique integer
bonded with next two columns..
Anyway - that should give you several possible avenues
to follow. Now I must get back to my paid employment.
Good luck
--> thank you
Dave
------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_sfd2d_oct
_______________________________________________
Net-snmp-coders mailing list
Net-snmp-coders@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/net-snmp-coders
