Re: [PHP] create a local temp table in local machine
Thanks, Bastien On Sep 28, 2013, at 3:24 PM, iccsi inu...@gmail.com wrote: 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] create a local temp table in local machine
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-007d9559d...@gmail.com... Thanks, Bastien On Sep 28, 2013, at 3:24 PM, iccsi inu...@gmail.com wrote: 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] create a local temp table in local machine
On Sep 28, 2013, at 6:00 PM, iccsi inu...@gmail.com wrote: 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-007d9559d...@gmail.com... Thanks, Bastien On Sep 28, 2013, at 3:24 PM, iccsi inu...@gmail.com wrote: 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] create a local temp table in local machine
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, Bastien wrote in message news:deb5dfe9-ec7f-4bc5-9e2e-acfb85039...@gmail.com... On Sep 28, 2013, at 6:00 PM, iccsi inu...@gmail.com wrote: 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-007d9559d...@gmail.com... Thanks, Bastien On Sep 28, 2013, at 3:24 PM, iccsi inu...@gmail.com wrote: 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= -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] create a local temp table in local machine
Thanks, Bastien On Sep 28, 2013, at 8:24 PM, iccsi inu...@gmail.com wrote: 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] create a local temp table in local machine
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-64cd8444f...@gmail.com... Thanks, Bastien On Sep 28, 2013, at 8:24 PM, iccsi inu...@gmail.com wrote: 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php