create a local temp table in local machine

[iccsi]

I need create a local table on the local machine.
I would like to know is it possible to down on server side or client side or
jQuery to do the work.
Your information and help is great appreciated,

regards,


Iccsi,

[Bastien]

Thanks,

Bastien

Post by iccsi
I need create a local table on the local machine.
I would like to know is it possible to down on server side or client side or jQuery to do the work.
Your information and help is great appreciated,
regards,
Iccsi

If you're looking to create a SQl table then most but not all browsers can use SQLite locally for data storage ( it does require newer browsers).

You haven't stated the goal for this so other options could include sending csv or json data down to the browser and using jquery, angular or some other JS framework to manipulate that data may also be an option

[iccsi]

Thanks for the message and help,
because I use jQuery autocomplete which has performance issue for thousands
records due to network load data.
I want to load the data to local table to resolve performance issue, if it
possible I can load to an array in the memory.

Thanks again for helping,

Regards,

iccsi,

"Bastien" wrote in message news:2FD3037D-F68D-47B3-AC4F-***@gmail.com...



Thanks,

Bastien

Post by iccsi
I need create a local table on the local machine.
I would like to know is it possible to down on server side or client side
or jQuery to do the work.
Your information and help is great appreciated,
regards,
Iccsi

If you're looking to create a SQl table then most but not all browsers can
use SQLite locally for data storage ( it does require newer browsers).

You haven't stated the goal for this so other options could include sending
csv or json data down to the browser and using jquery, angular or some other
JS framework to manipulate that data may also be an option

[Bastien]

Post by iccsi
Thanks for the message and help,
because I use jQuery autocomplete which has performance issue for thousands records due to network load data.
I want to load the data to local table to resolve performance issue, if it possible I can load to an array in the memory.
Thanks again for helping,
Regards,
iccsi,
Thanks,
Bastien

Post by iccsi
I need create a local table on the local machine.
I would like to know is it possible to down on server side or client side or jQuery to do the work.
Your information and help is great appreciated,
regards,
Iccsi

If you're looking to create a SQl table then most but not all browsers can use SQLite locally for data storage ( it does require newer browsers).
You haven't stated the goal for this so other options could include sending csv or json data down to the browser and using jquery, angular or some other JS framework to manipulate that data may also be an option

I had exactly this situation, large list with the autocomplete. I cached the list to a JS file and ran the autocomplete from that. It works well if the list is relatively static which mine was. It will be tougher if the list is dynamic, but you could send the data down after the initial page load.

HTH

Bastien

[iccsi]

Thanks for the information and help,
Yes, my data is pretty much static,
Can you please give me some link for the solution?
It is the solution I am looking for my current situation,

Thanks a million for helping,

Regards,

Iccsi,

Post by iccsi
Thanks for the message and help,
because I use jQuery autocomplete which has performance issue for
thousands records due to network load data.
I want to load the data to local table to resolve performance issue, if it
possible I can load to an array in the memory.
Thanks again for helping,
Regards,
iccsi,
Thanks,
Bastien

Post by iccsi
I need create a local table on the local machine.
I would like to know is it possible to down on server side or client side
or jQuery to do the work.
Your information and help is great appreciated,
regards,
Iccsi

If you're looking to create a SQl table then most but not all browsers can
use SQLite locally for data storage ( it does require newer browsers).
You haven't stated the goal for this so other options could include
sending csv or json data down to the browser and using jquery, angular or
some other JS framework to manipulate that data may also be an option

I had exactly this situation, large list with the autocomplete. I cached the
list to a JS file and ran the autocomplete from that. It works well if the
list is relatively static which mine was. It will be tougher if the list is
dynamic, but you could send the data down after the initial page load.

HTH

Bastien=

[Bastien]

Thanks,

Bastien

Post by iccsi
Thanks for the information and help,
Yes, my data is pretty much static,
Can you please give me some link for the solution?
It is the solution I am looking for my current situation,
Thanks a million for helping,
Regards,
Iccsi,

I don't have a link unfortunately. The system I did it for is proprietary. But I do recall it was a pretty switch in the JS to view the list from the static file. The JS file with the static data was just an array and the autocomplete looked at that as the data source

Sorry

Bastien

[iccsi]

Thanks for the message,
Do you have any information how to create JS file and how to access from
jQuery auto complete?
Thanks again for helping,

Regards,

Iccsi,



"Bastien" wrote in message news:57469E24-56E6-40C9-8176-***@gmail.com...



Thanks,

Bastien

Post by iccsi
Thanks for the information and help,
Yes, my data is pretty much static,
Can you please give me some link for the solution?
It is the solution I am looking for my current situation,
Thanks a million for helping,
Regards,
Iccsi,

I don't have a link unfortunately. The system I did it for is proprietary.
But I do recall it was a pretty switch in the JS to view the list from the
static file. The JS file with the static data was just an array and the
autocomplete looked at that as the data source

Sorry

Bastien